Ms Sql Database Senior Engineer

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 on-shore and off-shore 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 organization's 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/timeline-oriented 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 industry-standard 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.