Company:
DMI
Location: Cincinnati
Closing Date: 04/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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, integrity checks, and reconciliation processes to ensure data consistency across the system, particularly with large telecom billing and usage datasets.
Develop systems to quickly identify discrepancies between parsed summaries and detailed records, working closely with the Expense Management team to ensure accurate data handling.
Support development teams in testing and validating new features to ensure databases perform optimally in production environments.
Collaboration and Leadership:
Work closely with the development and product teams to ensure database designs align with product goals and meet performance benchmarks.
Provide technical guidance and mentoring to junior engineers, developers, and other team members regarding database best practices and performance optimization.
Participate in database migration and upgrade projects, ensuring smooth transitions with minimal downtime.
Qualifications:
Education and Years of Experience:
Education: Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field. Master’s Degree in a relevant field is preferred but not required.
Certifications: Relevant certifications in Data Science, Machine Learning, or AWS Cloud Services are highly desirable.
Experience: 5+ years of experience as a Database Administrator or Database Engineer, with hands-on experience managing complex databases for SaaS products.
Required and Desired Skills/Certifications:
Python Proficiency: Experience with Python for database automation tasks, scripting, and data manipulation.
SQL Proficiency: Strong proficiency in SQL, including writing, optimizing, and debugging complex queries. Familiarity with stored procedures, triggers, and indexing strategies.
Backup and Recovery: Strong knowledge of backup strategies, disaster recovery planning, and database replication techniques to ensure data resilience.
Data Migration: Experience with data migration strategies, schema evolution, and database upgrades with minimal disruption to ongoing operations.
Analytical Skills: Strong problem-solving skills with the ability to diagnose and resolve database performance issues under pressure.
Cloud (AWS): In-depth knowledge of cloud-based database solutions, with proven experience using AWS services such as RDS, Aurora, DynamoDB, Redshift, and S3.
Telecom Industry: Familiarity with telecom data and experience working with billing, usage records, and cost analysis in the telecom space is a strong plus.
PostgreSQL Expertise: Familiarity with PostgreSQL and its advanced features such as partitioning, replication, and high-availability setups.
Advanced Machine Learning: Experience with deep learning frameworks like TensorFlow or PyTorch and knowledge of advanced topics such as natural language processing (NLP) and reinforcement learning is a plus.
DevOps and Automation: Familiarity with CI/CD pipelines, version control for databases, and collaboration with DevOps teams to ensure smooth database deployments.
Data Modeling: Strong understanding of data modeling principles for large-scale, high-transaction systems, especially in the telecom or SaaS space.
Agile Methodology: Experience working in Agile development environments, participating in sprint planning, and collaborating in cross-functional teams.
Min Citizenship Status Required: Must be a U.S. Citizen
Physical Requirements:
Ability to work in an office environment.
Ability to sit for long periods of time.
Ability to utilize a keyboard and mouse.
Ability to work in front of a computer screen for long periods of time.
Location: Cincinnati, OH
Working at DMI:
DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:
Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.
Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.
Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.
Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.
Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.
No Agencies Please
Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.
#LI-EK1
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, integrity checks, and reconciliation processes to ensure data consistency across the system, particularly with large telecom billing and usage datasets.
Develop systems to quickly identify discrepancies between parsed summaries and detailed records, working closely with the Expense Management team to ensure accurate data handling.
Support development teams in testing and validating new features to ensure databases perform optimally in production environments.
Collaboration and Leadership:
Work closely with the development and product teams to ensure database designs align with product goals and meet performance benchmarks.
Provide technical guidance and mentoring to junior engineers, developers, and other team members regarding database best practices and performance optimization.
Participate in database migration and upgrade projects, ensuring smooth transitions with minimal downtime.
Qualifications:
Education and Years of Experience:
Education: Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field. Master’s Degree in a relevant field is preferred but not required.
Certifications: Relevant certifications in Data Science, Machine Learning, or AWS Cloud Services are highly desirable.
Experience: 5+ years of experience as a Database Administrator or Database Engineer, with hands-on experience managing complex databases for SaaS products.
Required and Desired Skills/Certifications:
Python Proficiency: Experience with Python for database automation tasks, scripting, and data manipulation.
SQL Proficiency: Strong proficiency in SQL, including writing, optimizing, and debugging complex queries. Familiarity with stored procedures, triggers, and indexing strategies.
Backup and Recovery: Strong knowledge of backup strategies, disaster recovery planning, and database replication techniques to ensure data resilience.
Data Migration: Experience with data migration strategies, schema evolution, and database upgrades with minimal disruption to ongoing operations.
Analytical Skills: Strong problem-solving skills with the ability to diagnose and resolve database performance issues under pressure.
Cloud (AWS): In-depth knowledge of cloud-based database solutions, with proven experience using AWS services such as RDS, Aurora, DynamoDB, Redshift, and S3.
Telecom Industry: Familiarity with telecom data and experience working with billing, usage records, and cost analysis in the telecom space is a strong plus.
PostgreSQL Expertise: Familiarity with PostgreSQL and its advanced features such as partitioning, replication, and high-availability setups.
Advanced Machine Learning: Experience with deep learning frameworks like TensorFlow or PyTorch and knowledge of advanced topics such as natural language processing (NLP) and reinforcement learning is a plus.
DevOps and Automation: Familiarity with CI/CD pipelines, version control for databases, and collaboration with DevOps teams to ensure smooth database deployments.
Data Modeling: Strong understanding of data modeling principles for large-scale, high-transaction systems, especially in the telecom or SaaS space.
Agile Methodology: Experience working in Agile development environments, participating in sprint planning, and collaborating in cross-functional teams.
Min Citizenship Status Required: Must be a U.S. Citizen
Physical Requirements:
Ability to work in an office environment.
Ability to sit for long periods of time.
Ability to utilize a keyboard and mouse.
Ability to work in front of a computer screen for long periods of time.
Location: Cincinnati, OH
Working at DMI:
DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:
Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.
Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.
Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.
Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.
Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.
No Agencies Please
Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.
#LI-EK1
Share this job
Useful Links