SQL Database Administrator

Database Administrator Job ID 2024-27357 Category Analytics/ Data Analysis Location US-OH-Cincinnati About DMI DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100 employees globally and has been continually recognized as a Top Workplace in both regional and national categories. About the Opportunity DMI, LLC is seeking an experienced Database Administrator (DBA) to join our technical team to architect, manage, and optimize the data infrastructure that powers our Telecom Expense Management SaaS platform. The ideal candidate will bring a passion for data architecture and performance optimization, coupled with a strong technical background in Python, SQL, and AWS. This person will be responsible for maintaining the integrity and performance of our database systems while enabling the development team to efficiently access and manipulate data in real time. In this role, you will collaborate with cross-functional teams, including developers, data engineers, and system administrators, to ensure that our databases support product features and data-driven decision-making processes. You will be entrusted with managing large volumes of complex data, improving query performance, and ensuring the reliability of mission-critical services for our enterprise customers. Duties and Responsibilities: Database Architecture and Design: Design, implement, and manage scalable relational database solutions that support our TEM platform. Define and enforce database architecture best practices, including schema design, indexing strategies, and partitioning methods to handle large datasets efficiently. Lead database capacity planning efforts to ensure system scalability as the platform grows in both data volume and user base. Performance Optimization and Monitoring: Continuously monitor database performance, identifying bottlenecks, slow queries, and areas for improvement. Optimize complex SQL queries to minimize response times and improve the overall system performance. Implement database performance tuning techniques, including indexing strategies, query optimization, and efficient use of database resources. Data Management and Automation: Develop and manage ETL (Extract, Transform, Load) processes to integrate and process data from multiple telecom carriers and other sources. Write and maintain Python scripts for data ingestion, migration, backup automation, and process automation tasks to streamline operations. Ensure data accuracy, consistency, and reliability across all environments, from production to development. Cloud Database Management (AWS): Manage cloud databases hosted on AWS, including Amazon RDS, Aurora, DynamoDB, and Redshift to ensure high availability, security, and performance. Implement and maintain backup, replication, and disaster recovery strategies using AWS-native tools. Collaborate with the DevOps team to automate database deployments and monitor database health through AWS CloudWatch and other monitoring tools. Data Security and Compliance: Implement and enforce database security measures, including data encryption, access control, and auditing to ensure compliance with data protection regulations (e.g., PCI, GDPR). Establish and maintain data governance policies to manage access control, data retention, and regulatory compliance requirements. Data Quality and Integrity: Conduct data validation, integ