Database Engineer

TechDigital Group; Overland Park (KS); Hybrid; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a Senior Database Engineer to lead cloud migration efforts and ensure robust database security. In this role, you will oversee the migration of databases to cloud platforms, implement security measures, and develop disaster recovery plans. You will work closely with development teams to optimize database performance and ensure efficient data flow. This position offers a unique opportunity to work at the forefront of database technology, utilizing skills in Oracle RDBMS, PL/SQL, and AWS RDS. If you are passionate about database engineering and looking for a challenging role, this opportunity is perfect for you.

Qualifications

• 5-6 years of experience with Oracle RDBMS, database migration, and management.
• 2-3 years of PL/SQL programming and performance tuning expertise.

Responsibilities

• Oversee database migration to the cloud, ensuring data integrity and minimal downtime.
• Implement security measures and maintain disaster recovery plans for databases.

Skills

Oracle RDBMS

Database Migration to Cloud

Database Security Management

PL/SQL programming

AWS RDS

GoldenGate

Scripting (shell, Python, Go)

Git & CI/CD tools

Communication Skills

Tools

ETL tools

Job description

Job #: 1532
Pay Rate: Not Specified
Job type: contractor
Location: Overland park, KS

Role: Sr. Database Engineer
Mandatory skill: Database Migration to Cloud, Database Security Management, Database Design
Location: Overland Park, KS (day 1 onsite - 3 days work from office)

Responsibilities

• Hands-on driver for Database Migration to Cloud: Oversee the migration of databases to the cloud, ensuring minimal downtime and data integrity.
• Database Security Management: Implement and maintain robust security measures to protect sensitive data and ensure compliance with industry standards and regulations. Perform regular security scans on all databases to ensure compliance with security standards and policies. Ensure security defects are resolved within SLA.
• Disaster Recovery: Develop and maintain comprehensive disaster recovery plans to ensure data integrity and availability in case of system failures or disasters. Own and drive disaster recovery (DR) plans (for db) and ensure recovery time objectives (RTO) and recovery point objectives (RPO) are met for all databases.
• Database Design: Design databases for high availability, scalability, and performance that meet platform SLIs.
• Collaboration with Development Teams: Work closely with software development teams to integrate databases with applications and ensure efficient data flow.
• Performance Monitoring and Tuning: Continuously monitor database performance and implement tuning measures to optimize query execution and resource utilization. Obtain and analyze Automatic Workload Repository (AWR) reports to identify performance bottlenecks and suggest tuning improvements. Conduct thorough SQL code reviews, optimize queries for performance, and implement best practices.
• Test Data Management: Introduce and maintain automated processes to simplify non-production environment (NPE) test data management.
• Database Optimization: Implement data archival and cleanup strategies.
• Work with dev teams on identifying and cleanup of deprecated/unused users, objects, and schemas to simplify the databases.
• Evaluate and propose alternative technologies to simplify the database footprint.
• Task Automation: Develop automation scripts for routine database tasks. Actively integrate with CI/CD pipelines where possible.

Skills

• At least 5-6 years of hands-on Oracle RDBMS experience including developing, designing and managing databases independently; Experience in data migration and noSQL esp. Graph DB is good to have.
• At least 2-3 years of PL/SQL programming, performing reviews and performance tuning.
• At least 1–2 years experience in using GoldenGate for data replication.
• At least 1-2 years of experience in creating, managing AWS RDS and integration with application platforms, and IAM role management.
• Experience in ETL tools is good to have.
• At least 3-4 years of scripting (shell, py, go or similar higher-level programming lang).
• Must have experience with Git & CI/CD tools, able to navigate and work independently.
• Good communication and articulation skills that adapt to different stakeholders and audience.