SQL server DBA
Job Description:
Skills |
No of positions |
Relevant experience level |
Preferred Job Location |
SQL Server DBA |
1 |
6 to 8 years |
Bangalore |
Job Description
Team : Infrastructure – Database Team
Designation: SQL Server DBA
Job Role:
Should be having 6-8 Yrs. of experience as SqlServer DBA
Essentials:
Minimum Knowledge/Qualifications;
- Bachelor's Degree, IT, Computer Science or related field. Equivalent technical experience may be substituted for educational requirement
- 3 to 4 years implementation/administration of relational databases with a strong understanding of SQL Server (2005, 2008, 2012, 2014 and 2016) in a production environment
- Strong understanding of “Always-On” and “Azure”
- Excellent understanding of and experience with relational database architecture and database implementations/monitoring/maintenance with the primary focus on SQL server
- Strong T-SQL and stored procedure skills
- SQL Feature configurations
- Writing/creating stored procedures
- Creating DB users/logins and security management
- Ability to run traces, performance monitoring, blocking and good problem solving skills are required
- Experience working cluster and virtual environments
- Experience with SQL installations and replication setup
- Experience with routine database maintenance operations – modifying SQL Agent jobs, backups and restores, knowledge of reindexing
- Experience working with multiple databases and multiple SQL servers in a production and non-production environment
- Understanding Applications and related database features that can be leveraged to improve performance
- Experience in analyzing database usage and proactive steps to ensure SLA levels.
- Excellent written and verbal communication skills
- Excellent analytical and troubleshooting skills
- Working with support case tool/application
- Knowledge of Windows operating system – familiar with Windows 2008, XP, 7 or higher.
- Knowledge working with Outlook – emails, calendar, managing rules
- Working with Windows RDP and application.
Duties & Responsibilities Include;
- Problem management - analyze & fix reported problems; work with other team members in troubleshooting problems
- Troubleshooting – Performance and other issues.
- Proactive database monitoring for performance and other problems
- Testing Upgrade packages
- Preparing Upgrade packages
- Performing non-prod restores/refreshes
- Expanding data files
- Managing disk space and capacity planning
- Creating/adjusting SQL Agent Jobs
- Database migrations
- SQL Server installs (cluster and non-cluster) and builds
- Working with cluster systems and Virtual servers
- Creating stored procedures
- Responding and replying to database support tickets and emails
- On-call support – pager rotation, work weekends, evenings
- Team player, fast learner, work in a fasted paced environment, share knowledge
- Detail oriented self-motivator with time-management skills
- Production support for TB+ databases
Specialized Skill-Set:
Scripting of BAT,VB Scripting, Understanding of Windows Administration(AD)
Experience:
6 to 8 yrs
Job-Location: Bangalore
No. of positions: 1
Company Profile
--- Cloud --- provides Clients Cloud Advisory Consulting and Cloud Life Cycle Services aligning business, finance and technology worldwide. Leveraging the Cloud ecosystem, clients have world class choices in selecting proven cloud strategies and --- for their businesses. it also delivers worldwide Data Center, Cloud Rationalization, and Managed Service --- across to various clients.
Apply Now
- Interested candidates are requested to apply for this job.
- Recruiters will evaluate your candidature and will get in touch with you.