Position : Sr. Database Administrator (DBA)
Experience : 7 8 Years of experience
Education : B. Tech / MCA/ M. Tech
Job Location : Jodhpur Rajasthan (onsite)
Key Responsibilities:
- Responsible for documentation testing and debugging of small to large DB management.
- Performance Tuning Query Optimization and using SQL Profiler and other related monitoring and troubleshooting tools
- Scheduling backups and restoring from backups
- SQL administration and troubleshoot SQL code and design (stored procedures functions tables views triggers indexes and constraints)
- Create technical design recommendations for developing and integrating programs per written specifications.
- Troubleshoot and solve issues with production systems.
- Analyze create and implement database schemas and queries.
- Ability to write efficient complex queries against very large data sets model analyze and manage large volumes of data.
- Documentation skills for SQL processes and procedures
- Ensure performance security and availability of databases.
- Handle common database procedures such as upgrade backup recovery migration etc.
- Profile server resource usage and optimize and tweak as necessary
- Perform monitoring to ensure data reliability of all enterprise databases.
- Perform system upgrades as required for smooth operations of the databases.
- Modify and maintain existing applications based on the needs of the business
- Ensure that the database is properly indexed and optimized for maximum performance
- Collaborate with application developers to understand database requirements and design optimal solutions
Requirements:
- At least 5 years of relevant experience in MSSQL administration with experience in designing and maintaining complex MSSQL databases
- Must have experience as a DBA and postgre and MySQL
- Handle common database procedures such as upgrade backup recovery migration etc.
- Advanced knowledge of TSQL programming and optimization techniques
- Strong knowledge of MSSQL Server Management Studio SQL Profiler and other databaserelated tools
- Experience with database design patterns normalization and indexing strategies
- Ability to analyse and troubleshoot complex database issues
- Excellent communication and interpersonal skills
- Ability to work independently as well as in a team environment
- Strong problemsolving and analytical skills
Soft Skills:
Team work and collaboration with internal / external teams
Effective communication skills (listening expressing writing)
Need a person who is a very good team player good at analyzing problemsolving Debugging skills and Technical Support.
Critical thinking attention to detail (keen eye for identifying and resolving defects)
Creativity and problem solving.
Collaborate within and cross teams.
Participate effectively on other development activities like code reviews automation unit testing etc.
Please read the JD carefully and apply
Thanks & Regards
Gurpreet Kaur
Asal Jobs
sql,postgresql,code