TechnoGen
Oracle DBA
TechnoGen, Baltimore, Maryland, United States, 21276
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
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