Database Administrator
- As a Database Administrator supporting database migration and DevOps initiatives, you will focus on project delivery and support by deploying and configuring database solutions according to defined specifications. The target platform is predominantly MySQL on Amazon RDS/Aurora, with source data originating from disparate legacy systems.
- You will be responsible for migrating and transforming data, implementing ETL processes, and supporting automated database deployments within CI/CD pipelines. This role also includes administering existing database systems to ensure performance, availability, and reliability across production, staging, UAT, development, and test environments. Troubleshooting, patching, performance tuning, access control and system security will be among your chief areas of responsibility.
- In addition, you will support reporting solutions using tools such Amazon QuickSight, or other technologies, depending on project requirements.
Essential Functions / Key Areas of Responsibility
- Deploy and configure database environments based on predefined application specifications and schemas.
- Execute full and incremental data migrations from disparate legacy systems into MySQL RDS/Aurora environments.
- Develop and execute ETL processes and data pipelines to support scalable data movement and transformation.
- Automate database provisioning and configuration using Infrastructure as Code (IaC), including Terraform.
- Integrate database deployments into CI/CD pipelines using version control tools such as Git.
- Validate migrated data and ensure data integrity and alignment with business requirements.
- Monitor database health, performance, and availability across cloud and on-prem environments.
- Troubleshoot and resolve database performance issues, including query tuning and resource optimization.
- Administer existing database systems, including backup, recovery, patching, and ongoing maintenance.
- Implement and manage backup and recovery strategies, ensuring alignment with RPO/RTO requirements.
- Support high availability and disaster recovery solutions (e.g., RDS Multi-AZ, replication strategies).
- Ensure database security, including access controls, encryption, and auditing.
- Perform capacity planning and manage storage and resource utilization.
- Support development and testing teams with database provisioning, query optimization, and deployments.
- Deploy and maintain reporting solutions using tools such as QuickSight, BI platforms, or other reporting technologies.
- Document database configurations, processes, and operational procedures to support auditability and knowledge transfer.
- Participate in on-call support and incident response as required.
Minimum Requirements:
- Experience administering MySQL databases, preferably in Amazon RDS and/or Aurora environments.
- Experience migrating data from heterogeneous or legacy systems into cloud database platforms.
- Hands-on experience with ETL development, data transformation, and data validation techniques.
- Experience with Infrastructure as Code (Terraform preferred) and CI/CD pipeline integration.
- Strong SQL skills across multiple database platforms (MySQL required; SQL Server and/or Oracle preferred).
- Experience with database performance tuning, monitoring, and troubleshooting.
- Experience with backup and recovery strategies, high availability, and disaster recovery implementations.
- Familiarity with cloud platforms, particularly AWS.
- Experience working in Linux and Windows based environments.
- Strong problem-solving skills and ability to work independently with minimal supervision.
- Strong written and verbal communication skills.
- Bachelor’s degree in Computer Science, Engineering, or a related technical field, or equivalent experience.
Preferred Qualifications
- Experience with Amazon Aurora (MySQL-compatible)
- Experience administering multiple database platforms (e.g., SQL Server, Oracle)
- Experience with DevOps practices and tools, including Git and CI/CD frameworks
- Experience integrating databases with monitoring tools such as CloudWatch, OpenSearch, or similar platforms
- Experience supporting reporting tools such as Amazon QuickSight, OpenSearch dashboards, or other BI technologies
- Experience in cloud and hybrid (on-prem + cloud) environments
- Experience with automation and scripting (shell, Python, or similar)
- Experience working in regulated environments requiring auditability and compliance
Employee Benefits:
- At LanceSoft, full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits:
- Four options of medical Insurance
- Dental and Vision Insurance
- 401k Contributions
- Critical Illness Insurance
- Voluntary Permanent Life Insurance
- Accident Insurance
- Other Employee Perks
EEO Employer
LanceSoft is a certified Minority Business Enterprise (MBE) and an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications, merit, and business needs at the time.
Pay: $55.00 - $57.00 per hour
Work Location: In person
