Position:-Application Database Administrator
Location-Atlanta,GA(Onsite)
Duration-Long Term W2 Contract
Description:
As a Database Administrator, you will be responsible for ensuring theperformance, availability, and security of databases. You will work closely with development andinfrastructure teams to support our databases hosted in Azure Cloud. This role demands a solidunderstanding of database management, data analysis, and system security.
Responsibilities:
- Manage and maintain MS SQL Server databases and PostgreSQL on Azure Cloud.
- Install, configure, and upgrade database software and related products.
- Monitor database performance and optimize queries.
- Manage Data Warehouse and Data Analytics pipeleines.
- Implement and maintain database security policies and procedures.
- Perform database backups and recovery procedures.
- Troubleshoot database-related issues and provide corrective actions.
- Collaborate with development teams to optimize database schema and SQL queries.
- Implement and manage database replication, clustering, and high availability solutions.
- Ensure data integrity and availability through proper backup and disaster recovery.
- Evaluate and recommend database technologies and tools.
- Work closely with DevOps teams for IaaS and other database related activities.
Qualifications:
- 5-7 years of experience as a Database Administrator or similar role.
- Proficiency in managing Microsoft SQL Server and PostgreSQL on Azure.
- Knowledge of ETL/ELT data pipelines and Data warehousing on Azure.
- Experience with database performance tuning and optimization techniques.
- Solid understanding of database security and data protection.
- Experience with database backup, recovery, and replication.
- Strong knowledge of SQL and T-SQL scripting.
- Familiarity with database design, normalization techniques, and indexing.
- Experience on NoSQL and/or columnar databases like CosomsDB, MongoDB etc.
- Ability to troubleshoot database issues and perform root cause analysis.
- Excellent communication and interpersonal skills.
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
Preferred Skills:
- Certification in Microsoft SQL Server and Azure Database Administration.
- Experience with other cloud-based database technologies.
- Knowledge of PostgreSQL administration and optimization.
- Familiarity with DevOps practices and tools.
Best Regards,
Prashant Gaurav
Whiz Global LLC
Phone: +1 (803)820-6610
Email-Prashant.gaurav@whizglobal.com
LinkedIn-https://www.linkedin.com/in/prashant-singhji/
Address: 1555 Medlock Bridge Road
Suite 100, Johns Creek, GA 30097