Database Administrator - Spectraforce Technologies : Job Details

Database Administrator (DBA)Atlanta, Georgia 303206 MonthsGeneral Description and Classification Standards:

• As a Database Administrator, you are responsible for the planning, deployment, management, and optimization of SQL Server, Oracle, and MySQL databases across both on-premise and cloud environments.
• This role requires in-depth knowledge of database architecture, database management best practices, and database security standards.
• You will support devops and production environments, ensuring system stability, performance, and data integrity.
• This position operates as a fully seasoned professional level within the engineering team, carrying out complex tasks with minimal supervision.
• Multiple incumbents in a work group may attain this level based on experience and capability.

Supervision Received:

• Works under general direction with significant independence. You may take ownership of specific functions or programs and are expected to contribute expert-level knowledge to the team.

Essential Duties & Responsibilities:Database Architecture and Design

• Design, document, and implement database architecture for on-premise and cloud systems, ensuring scalability, availability, and disaster recovery.
• Define data structures, storage, and retrieval processes, including partitioning strategies and indexing optimization.

Performance Tuning and Optimization

• Regularly monitor database performance, troubleshoot issues, and implement optimizations for SQL Server, Oracle, and MySQL environments.
• Analyze query execution plans, optimize SQL statements, and maintain efficient data retrieval and processing.
• Implement load balancing, clustering, and failover solutions.

Security and Compliance

• Ensure compliance with organizational and regulatory data protection policies by implementing best-in-class database security practices.
• Manage access controls, encryption, and auditing features to protect data integrity and security.
• Coordinate with the cybersecurity team to implement threat detection and response practices.

Backup, Recovery, and High Availability

• Develop, test, and manage backup and recovery plans for all database environments, ensuring data can be restored with minimal downtime.
• Deploy high-availability configurations using replication, mirroring, and cloud-native solutions.

Database Automation and Scripting

• Automate routine database tasks using PowerShell, Python, or SQL scripts to streamline deployments, updates, and system maintenance.
• Collaborate with the DevOps team to integrate database processes into CI/CD pipelines for automated testing and deployment.

Documentation and Training

• Maintain comprehensive documentation on database architecture, configurations, processes, and troubleshooting protocols.
• Provide training and mentoring to junior staff and contribute to the knowledge base for database management.

Cloud and Hybrid Environments

• Design and implement databases in cloud environments such as Azure and AWS, including hybrid configurations for seamless data movement and management.
• Work with cloud-based tools, including Azure SQL Database, Oracle Cloud, and MySQL on Amazon RDS, and manage database migrations to/from cloud environments.
• Database Patching and Upgrade

Policy and Standards Development

• Establish and document policies and standards for regular database patching and upgrades across SQL Server, Oracle, and MySQL environments to ensure alignment with organizational security and performance requirements.

Decision Making:

• Employs best practices and organizational policies to execute tasks independently.
• Selects from multiple methods and procedures for optimal outcomes and recommends procedural changes as needed.

Leadership Provided:

• Serves as a mentor and technical resource to other team members, providing guidance on complex database issues.
• May act as a team lead on database projects and initiatives, assigning tasks and setting performance standards for database staff.

Knowledge, Skills & Abilities:Database Expertise:

• In-depth knowledge of SQL Server, Oracle, and MySQL, including experience with cloud solutions like Azure SQL, Oracle Cloud, and Amazon RDS.
• Performance Tuning and Query Optimization: Advanced skills in diagnosing and optimizing complex queries and database workloads.
• Security and Compliance: Strong understanding of database security practices, including access control, encryption, and regulatory compliance standards.
• Automation and Scripting: Proficient in scripting and automation (PowerShell, Python, SQL) for database operations and integration with DevOps workflows.
• Analytical Thinking and Problem Solving: Demonstrates critical thinking in troubleshooting complex database issues and designing resilient systems.

Data & Reporting:Data Centralization and Warehousing

• Design, implement, and manage centralized data repositories to support data warehousing and business intelligence needs, ensuring integration across multiple database environments including SQL Server, Oracle, and MySQL.
• Develop and maintain ETL (Extract, Transform, Load) pipelines to automate data ingestion from various sources into the central data warehouse, supporting structured and unstructured data.

Data Automation and Pipeline Management

• Build and manage automated data pipelines to streamline data flow from source systems to reporting layers, including real-time and batch data processing.
• Leverage tools such as Azure Data Factory, SSIS (SQL Server Integration Services), or Oracle Data Integrator to orchestrate data movement and transformation tasks.

Data Accessibility for Reporting and Analytics

• Ensure data sources are accessible, reliable, and structured to meet the needs of data analysts, business analysts, and other end-users.
• Optimize data models and database structures to support reporting tools, including Power BI, by providing accessible datasets and views that facilitate quick insights and visualizations.

Performance Optimization and Maintenance

• Continuously monitor and enhance data pipelines and ETL processes to ensure optimal performance and reduce latency in data availability.
• Implement data archiving and partitioning strategies to manage data growth and maintain reporting efficiency.

Documentation and Compliance

• Document data flows, pipeline configurations, and reporting data models to ensure transparency, reproducibility, and adherence to data governance standards.
• Collaborate with the data governance team to maintain data quality, security, and compliance with organizational and regulatory requirements.

Minimum Qualifications - Education and Experience:

• Bachelor's degree in Computer Science, Information Systems, or a related field. Equivalent professional experience may be considered in lieu of a degree.
• Professional experience managing SQL Server, Oracle, and MySQL databases.

Preferred Education & Experience:

• Master's degree in Computer Science, Information Systems, or a related discipline.
• Direct experience in database administration across on-premise and cloud environments.

Licensures and Certifications:Preferred: Not mandatory

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified Database Administrator (MCDBA) or equivalent modern certification
• Oracle Certified Associate (OCA) - specifically 19c, RAC, Oracle Database Appliance
• MySQL Database Administrator