Sr. Database Engineer

Sr. Database Engineer– We offer a competitive benefits package!

The Company:  GIA is the world’s foremost authority in gemology. GIA is a global organization with headquarters located in Carlsbad, CA. GIA in Carlsbad boasts a 17-acre ocean view campus that accommodates approximately 800 of its 3,400 total employees worldwide. It offers many competitive health and commuter benefits that promote the well-being of its employees as well as that of the environment.

The Location: This position is located in Carlsbad, California at our corporate headquarters.

What to expect:

• We offer competitive medical, dental, vision and matching 401-K plans
• Paid vacation, sick and holidays, tuition assistance, commuter benefits

The Environment:

• On-site cafe - affordable custom breakfast and lunch meals and Starbucks drinks!
• Economic friendly services - electric vehicle charging stations on-site
• Ergonomic assessments offered on-site and virtually

Job Overview:

Sr. Database Engineer is a technical role tasked with managing multiple databases that hold business critical data and support business operations. The individual in the role brings knowledge of modern database technologies and data structure design best practices. They will also provide strategic guidance and implementation of the corporate Business Intelligence solution and the corresponding data feeds. This role is an opportunity to be part of a dynamic high performing team and to be in the forefront of innovative technology.

Responsibilities:

• Analyze the needs of an organization and produce an effective database system according to their needs and specifications.
• Participate in the development and maintenance of strategic, architectural and tactical plans for the database and data warehouse environments; be conversant with, and cognizant of, the future direction of systems, how that direction impacts the company and how future and current database systems can be utilized for the company’s benefit.
• Provide technical leadership on database systems and solutions.
• Provide individual mentoring and training on databases and tools. Recommend, test, and evaluate new technologies, software tools; recommend and implement improvements.
• Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
• Ensure the efficiency of database code, the integrity of data structures, and the quality of data content.
• Write scripts to ensure data movement between various databases and ensure the scripts written are fault-tolerant and extensible.
• Set and maintain database standards.
• Monitor database performance and identify and implement optimization opportunities.
• Ensure the organization Disaster Recovery and Business continuity plans are robust and are staying up to date with the changing application and infrastructure landscape.
• Keep up to date with current trends in computing, application architecture, and cloud computing services.
• Ensure deliverables meet customer expectations for speed, quality, and value.
• Other duties as assigned.

Technical Competencies (Knowledge, Skills & Abilities):

• Experience working with Oracle ExaData / ExaCC as well as OCI
• Expert-level knowledge of SQL, PL/SQL, including stored procedures, functions, triggers, and views.
• Extensive experience working with Oracle database and with query tuning and troubleshooting.
• Ability to efficiently write database code without compromising data quality, privacy, or security.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
• Experience utilizing various high availability (HA) and disaster recovery (DR) options for Oracle Database.
• Knowledge of both relational and non-relational (NoSQL) databases
• Experience with cloud technologies is good to have.
• Experience with backup/recovery best practices.

EDUCATION AND EXPERIENCE

• Bachelor’s degree in Computer Science, Engineering or equivalent combination of education and related work experience.
• 4-5+ years of experience working with Oracle databases.
• Experience with version control systems, DevOps, continuous delivery, and continuous integration practices required.
• Experience of managing, owning and delivering high quality projects to objectives and within time scales required.

Physical Requirements / Work Environment

• Work is performed in a designated professional office workstation and environment.
• Extensive use of office equipment to include computer, calculator