Duration: LONG TERM
Location: REMOTE
Oracle DBA
The Senior DBA is a key member of our Enterprise Database Engineering and Solutioning (EDES) team, working to ensure that GEICO's data is secure, reliable, and available across our range of business systems from sales to service to billing and claims. The selected candidate will primarily work with application development teams to do deep dive analysis of slow performing Queries, Stored Procedures, and perform tuning activities in a range of database systems. The ideal candidate is comfortable working in an advisory capacity with software engineers, familiar with Scrum/Agile processes, and has excellent database and scripting, analytical, decision-making, and problem-solving skills backed with good verbal and written communication.
Position Responsibilities:
-
As a Senior Engineer on the EDES team, you will:
Provide technical leadership to engineering teams utilizing Oracle, PostgreSQL, and related technologies
Own the complete solution across entire life cycle while utilizing strong problem-solving ability
Influence and build vision with product managers, team members, customers, and other engineering teams to solve complex problems for building enterprise-class business applications
Triage and optimize database-, application-, and platform-related performance issues
Hold accountability for the quality, usability, and performance of on-premises and cloud-based database solutions
Lead architectural design sessions and code reviews to elevate the quality of database engineering across the organization
Practice continuous integration and continuous development (CI/CD) in an Agile environment (Scrum/Kanban/SAFe), Infrastructure as code, PowerShell scripting, OCI portals, and Monitoring systems
Mentor mid-level to senior team members in Oracle DBA, PostgreSQL, and related technology
Share best practices and improve processes within and across teams
Qualifications:
-Extensive knowledge and experience with database administration, installation, configuration, upgrades, and maintenance, across different versions and platforms working in a large-scale, multi-platform database environment (Oracle, PostgreSQL, SQL Server, etc.)
Expertise in database tuning and performance optimization, including monitoring, troubleshooting, and resolving issues related to SQL queries, indexes, tablespaces, memory usage, and storage capacity, in Oracle and PostgreSQL environments
Advanced proficiency in backup and recovery strategies, disaster recovery planning, and high availability solutions, such as RMAN, Commvault, RAC, Data Guard, and GoldenGate
Strong understanding of database security principles and best practices, including user authentication, authorization, encryption, and auditing, as well as compliance with industry standards and regulations, in Oracle and other DBMS environments
Proficiency in scripting and automation for Oracle, using tools such as SQL*Plus, PL/SQL, Shell scripting, and scheduling utilities, and for PostgreSQL, using tools such as pgAdmin, PostgreSQL CLI, extensions like PostGIS, and Bash scripting, to streamline administrative tasks and reduce manual efforts in in both DBMS environments
Proficiency in programming languages including PL/SQL, SQL, Shell scripting, and PowerShell, with additional knowledge of languages like Python, Java, or C# for database integration and custom solution development
Ability to design and implement database architectures and solutions that meet business requirements, performance goals, and scalability needs, while ensuring data integrity, consistency, and availability, in Oracle and PostgreSQL environments
Familiarity with other Oracle technologies and products such as Enterprise Manager, AWR reports, WebLogic Server, Fusion Middleware, and E-Business Suite, and their integration with databases
Expertise in migrating databases from Oracle to PostgreSQL or vice versa, including understanding the differences and similarities between the two database management systems
Familiarity with SQL Server database administration, including installation, configuration, maintenance, and performance tuning, as well as familiarity with T-SQL and SSMS
Familiarity with cloud-native database services, such as Azure Database for PostgreSQL and Azure SQL PaaS, and their integration with on-premises systems
Flexibility to support 24x7 mission critical databases
Ability to develop efficient solutions that meet the long-term strategic goals of the organization
Strong understanding of Agile principles
Must have strong analytical skills, be able to learn quickly and work in a fast-paced environment
Must be able to perform under pressure, multitask, prioritize, and show appropriate sense of urgency
Must have excellent communication skills (written, verbal, and presentations)
Must be self-motivated and be able to work independently, while also working as an integral part of a team
Experience:
-4 years of professional software development experience with database technologies
3 years of experience with data architecture and design
3 years of experience with AWS, GCP, Azure, OCI or another cloud service
2 years of experience in open-source frameworks
Education
Bachelor's degree in Computer Science, Information Systems, or equivalent education or work experience