About the role
Principal Consultant, SQL Server DBA
In this role, you will be responsible for coding, testing and delivering high quality deliverables, and should be willing to learn new technologies.
Responsibilities
- Be a hands-on Database Administrator responsible for the design, maintenance, integration and operational support for the MSSQL environment SQL Server 2016/2019/2022
- SQL Server DBA with strong azure cloud knowledge
- Continuously monitor performance of SQL server, application and scheduled job performance and work to improve performance as well as establish performance baselines.
- Provide high-level database support and guidance to both the Development and Infrastructure teams.
- Troubleshoot and provide advice on SQL Server performance issues and be able to work with application developers and provide recommendations.
- Ability to work in shifts to provide operations support.
- Maintains quality of service by establishing and enforcing organization standards.
- Own, resolve, and track all database incidents and requests across production, UAT, and development environments.
- Be responsible for ensuring data consistency and integrity across all database systems.
- Work closely with other IT resources (e.g. Windows Engineering team, Network Administrators) to create and implement new applications and technologies
- Implement and support production changes adherent to the change management/ release process
- Manage, design and implement backup, recovery, and high-availability processes for all database systems
Qualifications we seek in you!
Minimum Qualifications
- BE/B Tech/MCA
- Excellent written and verbal communication skills
Preferred Qualifications/ Skills
- Database Administration experience, preferably in financial services
- A demonstrated proficiency in supporting the database platform of a large organization.
- Flexibility to support the operations of our businesses 24/7
- A bachelor's degree in computer science / information technology or equivalent experience
- Experience in SQL 2016/2019/2022 database management and related products from Microsoft including PowerShell, Windows 2016/2019/2022 Server and desktop operating systems.
- Prior experience with SQL Clustering, Strong Transact-SQL & SQL Server Reporting Services (SSRS) and SQL Server Integration Services
- (SSIS) knowledge, Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Database capacity planning, and Users and Role creation and monitoring.
- Ability to quickly troubleshoot and resolve complex problems in a live environment.
- Excellent interpersonal skills and ability to articulate complex ideas and solutions to users.
- Expert knowledge and in-depth experience with the Microsoft platform and the following technologies:
- Self-motivation with the ability to work independently and as a strong team player.
About Apptad Inc
Apptad is Data and Business Analytics consulting company that enables large enterprises tame modern data complexities (variety, volume, velocity, and quality) to extract maximum value from its data assets. With more than 500 specialized data and analytics engineers across 10+ locations in US and India, Apptad is uniquely positioned to provide high quality consulting services in areas of cloud migration, core data platforms (customer and product), intelligent automations, business intelligence, data quality and governance, UX and UI and augmented intelligence.
Committed to deliver value beyond SOWs, Apptad customized engagement model has helped it serve 100's of customers with highest customer satisfaction score compared to its peers. Apptad is proud to boast of more than 95% customer retention rate over last 5 years. At the same time, tailored HR policies coupled with industry leading upskilling program has enable Apptad to clock less than 5 per cent attrition rate, something to envy about in current job market.
With its 20+ templatized offerings, expertise with 50+ technologies and 10+ practice communities, Apptad has been go-to partner for many of our long-term customers. Discover more about Apptad at www.apptad.com
About the role
Principal Consultant, SQL Server DBA
In this role, you will be responsible for coding, testing and delivering high quality deliverables, and should be willing to learn new technologies.
Responsibilities
- Be a hands-on Database Administrator responsible for the design, maintenance, integration and operational support for the MSSQL environment SQL Server 2016/2019/2022
- SQL Server DBA with strong azure cloud knowledge
- Continuously monitor performance of SQL server, application and scheduled job performance and work to improve performance as well as establish performance baselines.
- Provide high-level database support and guidance to both the Development and Infrastructure teams.
- Troubleshoot and provide advice on SQL Server performance issues and be able to work with application developers and provide recommendations.
- Ability to work in shifts to provide operations support.
- Maintains quality of service by establishing and enforcing organization standards.
- Own, resolve, and track all database incidents and requests across production, UAT, and development environments.
- Be responsible for ensuring data consistency and integrity across all database systems.
- Work closely with other IT resources (e.g. Windows Engineering team, Network Administrators) to create and implement new applications and technologies
- Implement and support production changes adherent to the change management/ release process
- Manage, design and implement backup, recovery, and high-availability processes for all database systems
Qualifications we seek in you!
Minimum Qualifications
- BE/B Tech/MCA
- Excellent written and verbal communication skills
Preferred Qualifications/ Skills
- Database Administration experience, preferably in financial services
- A demonstrated proficiency in supporting the database platform of a large organization.
- Flexibility to support the operations of our businesses 24/7
- A bachelor's degree in computer science / information technology or equivalent experience
- Experience in SQL 2016/2019/2022 database management and related products from Microsoft including PowerShell, Windows 2016/2019/2022 Server and desktop operating systems.
- Prior experience with SQL Clustering, Strong Transact-SQL & SQL Server Reporting Services (SSRS) and SQL Server Integration Services
- (SSIS) knowledge, Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Database capacity planning, and Users and Role creation and monitoring.
- Ability to quickly troubleshoot and resolve complex problems in a live environment.
- Excellent interpersonal skills and ability to articulate complex ideas and solutions to users.
- Expert knowledge and in-depth experience with the Microsoft platform and the following technologies:
- Self-motivation with the ability to work independently and as a strong team player.
About Apptad Inc
Apptad is Data and Business Analytics consulting company that enables large enterprises tame modern data complexities (variety, volume, velocity, and quality) to extract maximum value from its data assets. With more than 500 specialized data and analytics engineers across 10+ locations in US and India, Apptad is uniquely positioned to provide high quality consulting services in areas of cloud migration, core data platforms (customer and product), intelligent automations, business intelligence, data quality and governance, UX and UI and augmented intelligence.
Committed to deliver value beyond SOWs, Apptad customized engagement model has helped it serve 100's of customers with highest customer satisfaction score compared to its peers. Apptad is proud to boast of more than 95% customer retention rate over last 5 years. At the same time, tailored HR policies coupled with industry leading upskilling program has enable Apptad to clock less than 5 per cent attrition rate, something to envy about in current job market.
With its 20+ templatized offerings, expertise with 50+ technologies and 10+ practice communities, Apptad has been go-to partner for many of our long-term customers. Discover more about Apptad at www.apptad.com