Navaera Worldwide - SQL Server Database Administrator
Navaera Worldwide
Date: 3 weeks ago
City: Vadodara, Gujarat
Contract type: Full time
About Us
Navaera Worldwide is a global, full-service firm that specializes in advanced knowledge management products and services designed to help Financial organizations improve operational efficiency, Manage Risk, Detect Fraud and gain competitive advantage.
The privately held company has diverse clients around the world including major corporations in the financial services industry.
As a brand, Navaera Worldwide provides complex business products and solutions to small and large organizations through Navaera Global Services.
Navaera Worldwide has offices located in three continents with global headquarter based in New York.
Other offices are in Toronto, Canada & Baroda, India.
Job Title : Senior SQL Server Database Administrator.
Experience Range : 8 12 Years.
We are seeking a Senior SQL Server Database Administrator to join our Data Platform Engineering team.
The DBA will be responsible for the data platform environment including overseeing the development and maintenance of the databases, assessment, optimization for new as well as existing implementations.
In this role, he/she will work with architecture, application development and operations to help achieve a state-of-the-art data platform that meets current and future business objectives.
The ideal candidate has deep database administration experience and seeks to design/model highly performant databases and queries.
Above all other factors, the successful candidate is smart, driven, and wants to be part of a culture of innovation and creativity as we develop and define our unique market.
Problems You Will Solve
Navaera Worldwide is a global, full-service firm that specializes in advanced knowledge management products and services designed to help Financial organizations improve operational efficiency, Manage Risk, Detect Fraud and gain competitive advantage.
The privately held company has diverse clients around the world including major corporations in the financial services industry.
As a brand, Navaera Worldwide provides complex business products and solutions to small and large organizations through Navaera Global Services.
Navaera Worldwide has offices located in three continents with global headquarter based in New York.
Other offices are in Toronto, Canada & Baroda, India.
Job Title : Senior SQL Server Database Administrator.
Experience Range : 8 12 Years.
We are seeking a Senior SQL Server Database Administrator to join our Data Platform Engineering team.
The DBA will be responsible for the data platform environment including overseeing the development and maintenance of the databases, assessment, optimization for new as well as existing implementations.
In this role, he/she will work with architecture, application development and operations to help achieve a state-of-the-art data platform that meets current and future business objectives.
The ideal candidate has deep database administration experience and seeks to design/model highly performant databases and queries.
Above all other factors, the successful candidate is smart, driven, and wants to be part of a culture of innovation and creativity as we develop and define our unique market.
Problems You Will Solve
- Data Infrastructure upkeep ensuring 99.99% availability.
- Create new database clusters and be responsible for HA/DR Solutions using AlwaysON, Replication, Log shipping, etc. for business continuity and data growth.
- Liaise on installation, configuration & maintenance of SQL Server instances in a shared enterprise organization.
- Responsible for promoting application related objects/code (releases) and implement CI/CD for Database stack.
- Create and manage database schema objects including tables, indexes, views, stored procedures, and triggers.
- Administer security user accounts & database roles, schema, data encryption, etc.
- Support application developers and BI/BizOps/Data-science teams with database architecture, query optimization, data loads etc.
- Troubleshoot performance issues and suggest/implement optimizations.
- Work with and educate our dev team to make good schema design choices and optimize queries.
- Automate recurring DBA tasks.
- Be part of data platform engineering team on-call rotation.
- Monitor database environment for high availability and disaster recovery, and proactively identify and solve issues.
- Document, develop and enforce standards for best database practices.
- Create backups and maintain recovery policies and procedures.
- Establish and maintain database security structures, encryption, and SOX compliance procedures.
- Perform database tuning, coordinate application releases, and troubleshoot database issues including slowness and latencies.
- Automation scripts using Bash/Python/PowerShell/Git for managing database infrastructure.
- Understand the different wait types and reasons for query suspension and improve performance for application.
- BS or MS degree in Computer Science or Equivalent experience.
- 8-12 years DBA experience in developing, maintaining, and administering MS SQL Server 2017 and above.
- Experience setting up SQL server on premises a plus.
- Experience with SQL Server 2014-2019.
- Experience managing high volume, high concurrency environments and multi-TB OLTP databases.
- Expert level SQL skills.
- Experience coding and maintaining complicated SSIS Packages.
- Penchant for automation with PowerShell, Python or other data scripting languages a strong plus.
- Experience with other databases, including Postgres, MongoDB, Apache Cassandra, or Apache Hive is also a strong plus.
- Proven analytical and problem solving skills.
- A curious, self-motivated, resourceful, critical-thinker.
- Strong oral and written communication skills.
- Capable of meeting deadlines in a fast-paced, dynamic, environment.
- Trouble shooting, performance monitoring and tuning skills is a must.
See more jobs in Vadodara, Gujarat