What are the responsibilities and job description for the SQL DBA position at eTeam Inc?
Pay Rate; $48 - $52 / Hour
- Manage and administer SQL Server databases in various versions, including installation, configuration, and maintenance.
- Monitor and optimize database performance through query optimization, indexing, and other techniques.
- Implement and maintain high availability and disaster recovery solutions for SQL Server, Always-On, Replication ensuring minimal downtime.
- Ensure the security and integrity of databases by implementing access controls, encryption, SSL, TDE, and data masking.
- Develop and maintain database backup and recovery strategies to safeguard data.
- Plan and execute database migrations and upgrades while minimizing disruption.
- Develop and maintain automation scripts using PowerShell or similar tools to streamline database operations.
- Work with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for data integration and reporting needs.
- Implement and maintain database monitoring and alerting solutions to proactively address issues.
- Maintain accurate documentation of database configurations, procedures, and troubleshooting steps.
- Significant experience with SQL Server and its migration to AWS EC2 instances and AWS RDS.
- Experience in evaluation an on-premises Data environment and suggest the best fit target environment on AWS.
- Prior cloud database migration experience with sizing and performance tuning.
- Understanding in creating AWS / Azure Landing Zones and Security policies
- Strong understanding of core AWS / Azure services and AWS / Azure architecture best practices
- Hands-on experience cloud native migrations tools such as AWS / Azure Database Migration
- Service and AWS / Azure Schema Conversion Tool
- Good to have AWS / Azure, MCTS, MCITP, and / or MVP certifications.
- Strong experience in SQL tools such as OmniDB, DBeaver, SQL Developer and PGAdmin.
- Extensive experience in database security, backup and recovery, and performance monitoring standards.
- AWS Certified Solutions Architect - Associate and AWS Certified Database Specialty Certifications is a must.
- Strong written and verbal communication skills with the ability to create and present concepts and recommendations to the management.
Salary : $48 - $52
