What are the responsibilities and job description for the Oracle DBA-(Weekend & Shift/Remote) position at GEICO?
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
- Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience
Benefits:
At GEICO, we make sure you have the support and resources to leverage and develop your skills, secure your financial future, and take care of your health and well-being. GEICO continually seeks to provide a workplace where everyone can be their authentic self. To help achieve this goal, we support associate-led Employee Resource Groups that foster a true sense of community. Through GEICO’s competitive benefits offerings and various training and development opportunities, we have you covered with our Total Rewards Program* that includes:
- Premier Medical, Dental and Vision Insurance with no waiting period**
- Paid Vacation, Sick and Parental Leave
- 401(k) Plan
- Tuition Reimbursement
- Paid Training and Licensures
- Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.
**Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.
GEICO is proud to be an equal opportunity employer. We are committed to cultivating an environment where equal employment opportunities are available to all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO celebrates diversity and believes it is critical to our success. As such, we are committed to recruit, develop and retain the most talented individuals to join our team.
#AJ19
Annual Salary
$82,000.00 - $185,000.00The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations.
Salary : $82,000 - $185,000
