The Senior Database Manager is responsible to deliver results and build relationships over multiple teams leading and guiding the manager and team members. They will manage managers and individual contributors with process improvement, people and team development, contract and vendor relationships, and project deadlines. This position requires management experience in building and creating effective teams. In addition, it requires in depth knowledge and operational experience of large scale production SaaS rdbms, no-sql, stream processing systems. To be successful strong organizational and collaboration skills are a must.
Essential Job Duties
Manage availability and performance of multiple SaaS applications databases in 24x7x365 environment.
Manage production MSSQL team and team focused on mysql, aurora, mongodb, kafka, and elasticsearch.
Guide, mentor, teach, and direct teams and individuals to continually improve production SaaS environments.
Provides leadership working with development, deployment, infrastructure, and support to enhance the enterprise’s production SaaS products.
Provide leadership in architecture, developing database standards, and procedures. Establish benchmark criteria for evaluating alternate database products.
Provide technical expertise in database schema design, indexes, referential integrity, performance tuning, optimization, monitoring, and capacity management.
Manage team workflow, intake process, project prioritization and standardization.
Manage vendor relationships from contract renewals to negotiations.
Develop, manage and monitors department budget where delegated.
Performs all tasks in accordance with Agile project management methodologies, adhere to version & release management, scheduling, change control, security and applicable operational policies and procedures.
Provides escalation for on-call support to resolve and/or escalate production incidents or issues outside normal working hours including support during software deployment/release activities.
Work closely with managers and team members to plan out career path and goals to get there.
Education: Bachelor’s Degree in Computer Science or related field or equivalent work experience and knowledge.
10+ years in-depth experience in managing MSSQL in a high-volume production environment.
5+ years in managing, developing, mentoring Database Team via demonstrable skills.
Experience in a 24x7x365 SaaS web development environment.
In-depth and expert knowledge of OLTP, OLAP, SSIS, SSRS, ETL, BI, and Data warehouse
Knowledge of leading edge technologies for large database technologies, hardware associated with relational databases, optimizer strategies, tuning SQL queries to obtain optimal performance.
Expert knowledge of SQL Server.
Knowledge of Microsoft Operating Systems and Linux Operating Systems.
Knowledge of designing DBaaS systems on premise.
Knowledge of high availability & DR strategy for large complex database environments.
Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment.
Ability to Lead others in the development and adherence of best practices.
Ability to interact with many projects and project reviews; and gauge the level of interaction required.
Ability to work in a fast-paced and demanding environment.
Ability to communicate and interact with all levels as well as external customers.
Infrastructure knowledge of virtualization, servers, storage, network, load balancer, firewalls.
The following skills/experience not required but considered to be a plus:
Experience with continuous software deployment.
Experience with scripting languages (PowerShell, Python) and provisioning tools (Octopus Deploy).
Experience working in a Scrum Agile workflow.
Experience designing, migrating or building AWS applications.