Job description

About the position Responsibilities • Primarily Database reliability engineering, deployment, and support of Microsoft SQL Server database technology which include both on premise and cloud environments such as AWS and GCP. • Support Database Administration and Engineering in the design, development and deployment, and management of Microsoft SQL database environments. • Collaborate with all interested parties, gather requirements, and provide recommendation for database standards. • Provide technical expertise to design the most efficient and cost-effective solutions for Microsoft SQL Servers. • Install, configure, monitor, upgrade and maintain MSSQL databases in production and non-production environments. • Write, Develop, and maintain PowerShell and TSQL scripts for DB automation and application maintenance tasks. • Advance experience with automation of managerial and repetitive DBA tasks. • Experience with GENAI to automate database related workloads. • Work closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance target set. • Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms. • Implementation and Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions. • Manage, support, and maintain Microsoft SQL Server database technology and infrastructure, adhering to the architectural guidelines and policies. • Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in On-Call support. • Regular database capacity planning and archival solution related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same. • Provide DBA support for enterprise monitoring, backup, alerting, and security compliance solutions for SQL servers. • Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing. • Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues. • Ability to work well as a team and as an individual with minimal supervision. Requirements • 5 or more years of relevant work experience with a Bachelor's Degree or at least 2 years of work experience with an Advanced degree (e.g. Masters, MBA, JD, MD) or 0 years of work experience with a PhD. • Bachelors Degree in Computer Science or other technology field is a must. • 6-8 years of DBA experience with Microsoft SQL Server databases. • 2+ years of Cloud experience working on GCP or AWS or Azure. • Strong technical skills in TSQL and PowerShell programming to automate SQL Server operational repetitive tasks. • 2+ years of experience in leading team of size minimum of 3+ and working with Global teams is a plus for this position. • Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory. • Sound knowledge of all windows and SQL utilities, strong PowerShell knowledge and experience is a plus. • Solid understanding of network, storage, tiered application environments and security. • Solid knowledge in database replication technologies including Always-on, Goldengate, etc. and strong architectural engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements. • Have good experience in engineering processes supporting repetitive or frequent tasks in database administration or deployment. • Solid understanding and experience in maintain MSSQL technology lifecycle, and automation of MSSQL deployment. • Good engineering skills in developing enterprise solutions to support MSSQL in areas like backup, monitoring and alerting, security compliance, patching, etc. • Good interpersonal skills along with effective communication (both written and verbal) skills. • Demonstrate ability to solve complex systems and database environment issues. • Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs. • A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team. • Programming languages Python or C++ is plus for this position. • Work experience in a Financial Institute will be preferred. Benefits • Medical • Dental • Vision • 401 (k) • FSA/HSA • Life Insurance • Paid Time Off • Wellness Program

Requirements