As a Senior SQL ServerDBA you will be working with Bank of The West Engineering and Operation teams to develop, manage, govern and maintain enterprise SQL Server databases. This position is expected to have complete hands on as well and lead day-today activities as required.
You are a technology expert who loves being in the center of the action, and you will routinely manage complex software and systems issues ranging from distributed change propagation on live serving systems, to designing and deploying cost-aware database systems. Also, should work closely with application support/development teams, and the infrastructure teams in maintaining a reliable environment around systems hardware and operating systems ,server software.
Design, architect, and build databases based application systems from business requirements to planning and deploying test and production systems that are completely available and highly scalable
Automate and perfect operational DBA duties which will include installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning and site fail over/ switch over.
Interface with clients, network, hardware and system operations teams to resolve problems with application/database systems in a timely manner.
Follow change management process and participate in related meetings.
Responsible for managing Development, Test, QA and Production databases and implementing future SQL Server enhancements to meet the business needs of the end users.
Monitor database health - availability, reliability, performance, capacity planning, server clustering, replication, re-indexing. Tune system to ensure maximum system efficiency and 100% system availability. Resolve any problems that arise with the database
Develop, manage and test back-up and recovery plans and procedures during bi-annual Disaster Recovery exercise
Responsible for implementation and release of database changes as requested by the application team
Create and maintain database/application architecture and standards following Microsoft Best practices for physical structures, logical databases, user management.
Act as a database project leader for critical, time driven, visible projects, if needed.
Integrate/collaborate with application development and support teams on various IT projects.
Provide thought leadership and assist in setting strategic direction for Database, infrastructure and technology
Provide off hours support and maintenance as required, part of the 24x7 operations support on call rotations as needed
Expert level knowledge on latest versions of SQL Server database (2012 and above)
Strong SQL Server database administrator , including troubleshooting and fixing performance issues, replication, backup/restore etc.
Good understanding of Microsoft operating systems as needed to manage SQL Server Databases
Power Shell Scripting experience
Experience with SQL Server database architecture concepts.
Excellent customer service and operations/support temperament is key for this role
Hands-on experience with SQL Server Replication/Log Shipping, Always On
Proficiency working with Windows/Linux platforms with concrete knowledge of system administration/internals.
Ability to learn and support new application systems
Good technical leadership and communications skills , team player, and ability to work under pressure.
Performing Enterprise wide Database Upgrade and Migrations projects.
Hands-on experience on Database and SQL tuning