Database Developer

Noblesoft Technologies - Overland Park, KS

Full-time - Mid Level

Overland Park, KS

Professional, Scientific, and Technical Services

About the position

The Sr. Database Engineer at Noblesoft Technologies is responsible for overseeing the migration of databases to the cloud, ensuring data security, and maintaining high availability and performance of database systems. This role requires collaboration with development teams and involves implementing disaster recovery plans, optimizing database performance, and automating routine tasks.

Responsibilities

• Oversee the migration of databases to the cloud, ensuring minimal downtime and data integrity.
• Implement and maintain robust security measures to protect sensitive data and ensure compliance with industry standards and regulations.
• Develop and maintain comprehensive disaster recovery plans to ensure data integrity and availability in case of system failures or disasters.
• Design databases for high availability, scalability, and performance that meet platform SLIs.
• Work closely with software development teams to integrate databases with applications and ensure efficient data flow.
• Continuously monitor database performance and implement tuning measures to optimize query execution and resource utilization.
• Introduce and maintain automated processes to simplify non-production environment (NPE) test data management.
• Implement data archival and cleanup strategies.
• Work with development 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.
• Develop automation scripts for routine database tasks and actively integrate with CI/CD pipelines.

Requirements

• At least 5-6 years of hands-on Oracle RDBMS experience including developing, designing, and managing databases independently.
• Experience in data migration and NoSQL, especially 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 of experience in using GoldenGate for data replication.
• At least 1-2 years of experience in creating and 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 experience (shell, Python, Go, or similar higher-level programming language).
• Experience with Git and CI/CD tools, able to navigate and work independently.
• Good communication and articulation skills that adapt to different stakeholders and audiences.

Nice-to-haves

• Experience in ETL tools is good to have.
• Experience in data migration and NoSQL, especially Graph DB is good to have.