The MSSQL Database Administrator will serve as a member of the DemandTec Cloud Production Operations database team managing several production SQL Server. SSIS & SSRS instances. This position is essential to driving the overall flexibility, scalability and design of the infrastructure that support multiple SaaS offerings. This position will play a key role in creating high quality database architectures that are available, secure, reliable, and highly efficient databases.
Install and configure MS SQL Server instances in cloud, preferably on Azure
Maintain MSSQL schemas, tables, procedures, and permissions.
Manage Windows, Windows domains and SQL Server Security configurations
Manage SQL Server database and Log backups to Azure BLOB
Help drive migration from stand-alone SQL Server instance to Azure SQL
Monitor database and database maintenance jobs, creating indexes on a daily basis.
Monitor database performance, errors and perform analysis to find root cause
Understand applications supported and interaction of SQL Server with other application components.
Partner with application development teams in developing SQL Server Sps
Analyze and sustain capacity and performance for responsible areas.
Analyze and tune databases, queries, and stored procedures.
Understand and implement various mirroring and high availability technologies including mirroring, clustering, and log-shipping
Participate in application code reviews and make suggestions based on SQL Server best practices
Restore, rebuild, and recover database environments.
Develop good CI/CD pipeline for deploying releases and patches
Provide off-hours support for critical situations, releases, and upgrades.
Create and maintain scripts for task automation.
Evaluate and recommend the use of new database features and technologies.
3+ years of MSSQL database administration experience
2+ years SSIS SSRS administration experience
Working knowledge of any other Database administration is a plus.
Bachelorâs Degree in Information Technology
5+ years of MSSQL database administration experience
Be a better candidate than others by watching these Job-related videos.
Acoustic recruiting Database Administrator Experienced(0 to 3 Years) candidates candidates nearby Pune,.Acoustic vacancies for Database Administrator is recruited through Written-test, Face to Face Interview etc. Acoustic Company recruits a lot of Experienced(0 to 3 Years) candidates candidates every year based on the skills . The candidates with BE/B.Tech, Other Course are selected to full fill the vacancies in HR job field. The candidates nearby Pune, can apply for Database Administrator position in Acoustic. All candidates should have a degree or post-graduation in the required field based on the requirement mentioned. The jobs are available in Full Time basis. When it comes to the Acoustic recruitment, candidates are mostly chosen for the department of HR . To learn more about the current jobs and other details, it is better to go through official site of Acoustic and Teamlease.com. Find the latest jobs near you and near your home. So, that you don’t need to relocate. The Teamlease.com is a leading employment portal that researches the official site of Acoustic and provides all the details about the current vacancies, the application process, selection process, interview test details, important dates and other information. Search and apply for the top job positions in Acoustic and near your city and get a secured career.