Reporting to management on the DBA team activities.
Defining, documenting and maintaining DBA team processes.
Responsible for upgrades, performance monitoring, installations, managing replications, diagnosing system problems, disaster recovery testing and maintaining user accessibility.
Resolving complex issues involving: database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
Providing database administration, database security and production support, primarily in both cloud and onprem.
Managing physical database design and implementation, database security implementation and monitoring.
Provides hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.
Researching and recommending solutions that best meet business needs and enterprise operational requirements
Work closely with multiple application development team(s) to implement and support data-oriented development efforts.
Work closely with DevOps and Cloud teams to support various design, automation and cloud migration initiatives.
Champion and support cloud database solutions.
Act as a technical lead for a team of DBAs being the primary point in driving standard processes, troubleshooting methodologies and setting the tone for excellence.
Build positive relationships with internal and external customers/business users by providing excellent service/support and consistent communication.
Assist project teams with technical issues in all phases of a projects life cycle. This includes providing technical analysis / design services to the project through the delivery of recommended design.
Strong knowledge of performance tuning, capacity management, resource planning, integrity checks, configuration, patching.
Ability to write, troubleshoot and optimize scripts for maintenance and health check
Create and optimize database objects (stored procedures, functions, tables, views, triggers, indexes, constraints) in production
Proactively recommend and implement improvements to systems and processes
Create and maintain database documentation, standards and policies
Collaborate with development team regarding database related development such as ETL, Data Warehousing and Database Design.
Design/manage solutions to meet High Availability and DR requirements. Support DR initiatives
Process automation and scripting
Train and provide guidance to L2 team members to perform day-to-day operations tasks ensuring the availability, reliability and security of our solutions. Mentor L2 teams to effectively complete operational tasks and assist with projects when appropriate
Collaborative and strong communication skills
Open to new ideas, capabilities and technologies
Excellent analytical and problem solving skills, anticipates issues and deals with them proactively (Critical Thinking)
Sound judgment and personal integrity
Comfortable in an environment with flexible work schedules, 24/7 availability, and on-call rotation
Oracle. PostgreSQL, Aurora, MySQL, Vertica, MongoDB and NoSQL databases
Strong SQL foundation and knowledge of DB tools
Skilled in backups & disaster recovery
Bachelor’s Degree in Computer Science or Information Technology or related field and at least 3 years of increasing responsibilities in computer application system development or administration.
Extensive experience in database administration with at least 3 years in a lead role
3+ years of direct IT experience supporting database environments on on-prem and cloud infrastructure
Must have prior experience successfully leading or managing a team of technical IT resources with demonstrated progression of increased scope and complexity
The ability to successfully manage and deliver multiple projects/tasks simultaneously
Experience migrating applications/databases to AWS
Data Infrastructure Manager will support the organization in developing, operating and managing enterprise database environments.
Act as the DBA resource to ensure integrity, performance and reliability of all enterprise database systems.
Coordinate activities performed by the team, track and report on team activities, define and document team processes, troubleshoot escalated issues and will be hands-on in operational DBA tasks which involves database monitoring, performance tuning, backup and recovery, installation, maintenance, and disaster recovery.