Senior Database Administrator at Fusion Technology LLC in USA

Job description

• The DBA will work extensively with Amazon Aurora Postgres and Amazon DynamoDB, handling both the operational and developmental aspects of database management. The role involves working with cross-functional teams, maintaining high performance, and ensuring data security across complex, large-scale architectures.

Responsibilities

• Oversee routine patching, maintenance, and upgrades for Aurora Postgres and DynamoDB** to ensure system integrity and reliability.
• Implement patch management strategies to address security vulnerabilities and performance improvements.
• Implement robust security measures for database systems, including encryption, authentication protocols, access control, and regular auditing.
• Monitor and analyze database performance, identifying areas for improvement.
• Apply tuning techniques for query optimization, indexing strategies, and resource management to enhance overall performance.
• Address database slowdowns, perform root cause analysis, and apply corrective actions to maintain optimal performance.
• Develop and manage database backup strategies, including automated snapshotting and disaster recovery plans.
• Ensure high availability and reliability by creating scalable recovery solutions for both Aurora Postgres and DynamoDB.
• Collaborate with development teams to ensure smooth database connections in microservice architectures.
• Manage different database connection protocols, such as JDBC, ODBC, and other integration methods, to support various applications.
• Troubleshoot connection issues across development, testing, and production environments.
• Collaborate with DevOps teams to integrate database management into CI/CD pipelines and automate routine database tasks such as backups, replication, and deployment through scripting and DevOps tools.
• Use performance monitoring tools (e.g., AWS CloudWatch, Datadog) to proactively track and manage database health.
• Generate reports on system usage, performance metrics, and security compliance.
• Work with cross-functional teams, including development, security, and operations teams, to support enterprise-level applications.
• Engage with stakeholders to align database solutions with organizational goals and future scaling needs.

Requirements

• Security-cleared Professional: You have made it through the process of receiving a United States government security clearance - congratulations! We know you are a trustworthy intel professional because you have an active DOD Secret security clearance.
• Education is important to us: You have a Bachelor's Degree with 6-8 years of experience.
• Experience as a Database Administrator with a focus on Aurora Postgres and DynamoDB in large-scale, enterprise environments.
• Strong skills with Bash Scripting, experience related to automation and line experience is required.
• Proficiency in database maintenance, patching, security best practices, connection protocols, troubleshooting, and backup/recovery strategies.
• Strong experience with database tuning, query optimization, and performance monitoring tools.
• Solid understanding of microservices architectures and experience connecting databases to distributed systems.
• Experience with DevOps practices and automation of database tasks (scripting, CI/CD pipelines).
• Familiarity with cloud infrastructure (preferably AWS) and hands-on experience in managing databases in a cloud environment.
• Excellent problem-solving skills and the ability to work effectively in a collaborative, fast-paced environment.

Skills

Required

• Aurora Postgres
• DynamoDB
• Bash Scripting
• Database maintenance
• Patching
• Security best practices
• Connection protocols
• Troubleshooting
• Backup/recovery strategies
• Database tuning
• Query optimization
• Performance monitoring tools

Benefits

• Fusion Technology values its employees and works hard to ensure proper care for them and their families. We desire to compensate employees in a competitive, motivational, fair, and equitable way with other employers in the marketplace. Salary is only one component of employee compensation but an integral part of recruiting and retaining qualified employees. However, at Fusion Technology, we take a comprehensive approach and consider each employee's needs to tailor a compensation plan that provides financial security and peace of mind. Our competitive package includes a best-in-class matching 401K program, a comprehensive healthcare plan through Cigna, a competitive employer contribution to a health savings account, vision and dental plans, life insurance, short- and long-term disability, and personal leave, in addition to paid certifications and training.