Database Administrator

• Manage and maintain all databases, ensuring high availability and reliability.
• Perform regular database backups and recovery procedures.
• Monitor database performance, tuning for optimization and efficiency.
• Participate in the design, development, and maintenance of scalable and efficient data pipelines and databases.
• Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models.
• Recommend appropriate data storage and processing technologies based on project requirements.
• Develop and implement Extract, Transform, Load (ETL) processes to acquire, clean, and transform data from various sources into usable formats.
• Ensure data integrity, consistency, and quality throughout the ETL processes.
• Monitor and troubleshoot data integration workflows, identifying and resolving data-related issues and performance bottlenecks.
• Participate in the design, build, and maintenance of data warehouses and data lakes to support reporting, analytics, and business intelligence initiatives.
• Implement data partitioning, indexing, and optimization strategies to improve query performance and efficiency.
• Work with data consumers to understand their reporting and analysis requirements and provide appropriate data structures and schemas.
• Adhere to and enforce data governance policies, standards, and regulations.
• Implement data security measures, including access controls, encryption, and data masking techniques.
• Monitor data usage and access patterns, identifying and mitigating potential data security risks.
• Optimize data processes and infrastructure to improve performance, scalability, and reliability.
• Conduct performance tuning, query optimization, and indexing to enhance data retrieval and processing speed.
• Proactively identify and address system bottlenecks to ensure efficient data operations.
• Design, construct, implement, and maintain automated jobs and reports.
• Collaborate with cross-functional teams, business analysts, and IT systems analysts to understand their business requirements and provide data and custom application solutions.
• Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders.
• Stay updated with the latest industry trends, technologies, and best practices related to database administration.
• Manage the installation, configuration, and maintenance of database management systems (DBMS).
• Coordinate and oversee OS-level patching and updates for database servers.
• Perform routine and advanced system maintenance and monitoring tasks.

• As the Platform Database Administrator (DBA) for Aurora, serve as the architectural and operational anchor for high-scale database environments.
• Bridge the gap between technical data layers and production feature engineering.
• Take full ownership of database performance tuning, optimization strategies, and system reliability across core software suites.
• Sustain consistent system performance and reliability across 400+ database schemas, managing comprehensive schema migrations and tracking client-specific data growth metrics.
• Supervise AWS Aurora-specific environments, orchestrating cluster endpoint routing configurations, managing failover behaviors, executing parameter tuning, and troubleshooting data warehouse / read replica lags.
• Apply deep knowledge of InnoDB core internals to manage lock behaviors, resolve complex lock contentions, adjust buffer pool parameters, and systematically reduce purge lags across write-heavy database clusters.
• Diagnose and optimize heavy database pipelines utilizing INSERT...SELECT queries and computed-table patterns.
• Analyze Aurora instance utilization models against pricing factors to right-size compute resources and minimize I/O waste stemming from unoptimized queries.

Database Administrator jobs in Maine

See all jobs on JobTailor

Database Administrator

Platform Database Administrator, Aurora/MySQL