Job Description: As a MS SQL Database Senior Engineer you will be responsible for providing the highest technical expertise for the planning design implementation upgrade patching capacity planning and day to day operations for the Microsoft SQL Server database platforms including technical communications with the vendor. This role will also provide oversight mentoring and leadership to less experienced onshore and offshore staff. The successful candidate must be comfortable working on multiple dynamic projects simultaneously collaborating with database architects application teams information security teams and leadership at all levels of the organization.
Responsibilities for this role in working on an enterprise team supporting large highly complex databases include the following:
Provide the highest technical expertise for the planning analysis design implementation maintenance and control of the organizations MS SQL databases engaging with DBA architecture OSE and other partner teams to create efficient and consistent solutions. Lead the most complex or critical MS SQL initiatives that typically involve multiple disciplines and multiple business groups. Provide highest level of expertise in complex databases troubleshooting and problem resolution and drive continuous process improvement as preventive actions. Deliver next generation database technologies and provide technical leadership and recommendation into the future direction of database technology. Able to handle multiple/conflicting projects and deadlines; able to work on call and provide 24/7 production support. Demonstrate proficient communication skills with management application teams vendors and systems administrators. Interact with customers (internal / external) to meet process deliverables. Consult or develop best practices & SOP and promote these standards across the team. Mentor/Train DBA operations team in the installation configuration and maintenance of databases and/or database related products lead educational sessions. Skills Required: Strong analytical skills with high attention to detail and accuracy
Excellent verbal written and interpersonal communication skills
Working knowledge of Agile methodologies and tools Strong technical and task/timelineoriented skills necessary to ensure projects are completed in a timely and accurate manner Experience with Jira and Agile delivery Knowledgeable in the programming or scripting language Experience in leading the complex or critical data/ database management initiatives and projects Experience with large data sets transactional platforms or a combination of both Experience managing one or more industrystandard development tools or scripting languages 3 years supporting database implementations in a regulated banking or financial industry 7 years experience management of database technologies 3 years experience management of cloud native technologies 7 years of hands on SQL and query optimization 5 years of database object level design optimization 5 years of experience of designing and building complex resilient database systems 2 years of technical lead experience including resource management conflict resolution and negotiation skills for business and technical issues.
Extensive knowledge of application server connection pooling and session level optimization into the database Extensive experience in supporting the Systems Development Lifecycle to include:
Code reviews and optimization
Supporting unit integration quality performance and scalability testing
Understanding how to consult with development teams to construct a valid test harness that may be used to produce dependable results in testing at the database layer Extensive experience identifying developing and executing on action plans to resolve performance issues using tools such as:
Ability to write and maintain high quality documentation and or white papers
Demonstrated ability to quickly learn retain and apply good interpersonal skills and perform effectively under time pressure are critical skills required for this position
Demonstrated ability to interact effectively with a variety of contacts including senior and mid level managers. Remote Work : No
