SQL Server DBA
- Jade Global
- 5 - 10 years
- Hyderabad
- 8 months ago
- Email to a friend
- Report this job
Job Description
Key Responsibilities:
Database Management:
- Manage, configure, and maintainSQL Server databasesin high-availability environments (Active-Active).
- Ensure optimal database performance, tuning queries, and optimizing resources.
- Monitor and resolve database performance issues, minimizing downtime.
Cluster Setup and Management:
- Design, implement, and supportSQL Server AlwaysOn availability groupsandfailover clustering.
- Ensurehigh availabilityanddisaster recoveryacross multi-node SQL Server clusters.
- Monitor and manage cluster health, replication, and failover processes.
On-Prem to AWS Migration:
- Lead and execute migration ofon-premise SQL Server databasestoAWScloud, includingRDSandEC2setups.
- Plan, architect, and execute database migration strategies with minimal downtime and risk.
- Configure databases in AWS environments, ensuring scalability, performance, and security.
Backup, Recovery, and Disaster Recovery:
- Implement and managebackup and recoverystrategies to safeguard critical data.
- Test and maintaindisaster recoveryplans to ensure database availability during unforeseen events.
- Manage database replication between on-premises and cloud infrastructure.
Security and Compliance:
- Ensure databases adhere to security and compliance policies, implementingdata encryption,access control, andauditing.
- Regularly conductsecurity auditsand apply patches and updates to mitigate vulnerabilities.
- Collaborate with security teams to meet industry compliance standards.
Support and Troubleshooting:
- Provide24/7 supportfor production databases, ensuring rapid resolution of any issues.
- Troubleshoot and resolve complex database issues related to performance, availability, and security.
- Document procedures, guidelines, and best practices for maintaining and optimizing SQL Server environments.
Automation and Scripting:
- Automate routine database tasks, including backups, monitoring, and performance tuning using tools such asPowerShell,T-SQL, or other automation tools.
- Continuously improve efficiency and reduce manual intervention in database operations.
Collaboration:
- Work closely with development, infrastructure, and operations teams to ensure smooth database operations across all environments.
- Provide guidance and best practices for database design, development, and optimization.
Required Skills and Qualifications:
- 5+ yearsof experience as a SQL Server DBA in enterprise environments.
- Strong knowledge ofSQL Server clustering,AlwaysOn availability groups, andActive-Active setups.
- Experience withon-premises to AWS migrationfor SQL Server databases.
- Expertise inAWS RDS,EC2, and other AWS database services.
- Proven experience inperformance tuning,query optimization, anddatabase maintenance.
- Strong understanding ofbackup, recovery, anddisaster recovery strategies.
- Proficiency inT-SQL,PowerShell, and other automation scripting languages.
- Excellent troubleshooting, problem-solving, and communication skills.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Jade GlobalLocation(s): Hyderabad
Keyskills: amazon rds sql server sql amazon ec2 aws sql server database query tuning performance tuning disaster recovery sql server dba recovery database design high availability query optimization powershell troubleshooting clustering scripting languages
Similar positions
Jade Global
Jade Global is a premier Advisory, Integration, Testing, Cloud & Consulting Services, Business Solutions and IT Outsourcing company that services clients across multiple technology platforms. It is headquartered in San Jose, California with office in Irvine, US; Berkshire, UK and Pune, Hyderabad...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in