Lead, Database Administration

Job Description

As a Lead Database Administrator, you will work with other members of our DBA teams to develop and track key database measures and metrics. Your focus will be on evaluating runtime systems, building monitoring and incident response capabilities, and automating monitoring and automatic feedback systems for our development, staging, and production systems Key Qualifications: 9+ years of experience in a DBA role supporting 24/7 environment with on call duties as per team rotation. DBA will be responsible for supporting other database types (Postgres, DB2, aurora) in Saks environments. Demonstrated ability to mentor junior team members and develop internal experience in DBA best practices Experience with database migration from data center to Azure / AWS RDS. Managing Databases as IaaS, PaaS. Exposer to Azure VMs and /Azure SQL MI Experience with Automation of routine tasks and setup monitoring. Shell scripting, Powershell, PL/SQL for automation. Strongly desired : experience in the retail or fashion industries Appreciated: interest and curiosity for working in a variety of languages and frameworks with flexibility towards team and organizational adoption Role Description: Assist with issues relating to system performance: Diagnosis of SQL problems, Application Support and SQL Support Assist with the design and maintenance of systems, policies, and procedures for disaster recovery to ensure effective availability, protection, confidentiality of data, and integrity of data assets. Be a consultant in the review, planning, testing, and execution of business applications and database upgrades Develop and track key database measures and metric Good understanding of data models and assisting the application team providing recommendations for schema designs o Demonstrate extensive hands-on experience with SQL Server & Oracle with a particular emphasis on performance and tuning. Skills include, but are not limited to: Installations, migrations/upgrades, configuration, tuning and performance analysis, backup/restore/failover Ability to plan, scope and estimate work effort to produce high quality deliverables on time/on budget for Database project work Good understanding of Failover clustering and Log shipping Use quantitative and modeling techniques to forecast database capacity and growth trends On call duties per team rotation. Conduct research and make recommendations on database products, services, protocols, and standards in support of development efforts. Develop key automation, monitoring and performance tuning software Review and tune data access calls and stored procedures to ensure both individual database performance and overall system performance Provide technical leadership in the design, implementation and management of our database environments Your Life and Career at Saks: Exposure to rewarding career advancement opportunities A culture that promotes a healthy, fulfilling work/life balance Benefits package for all eligible full-time employees (including medical, vision and dental). An amazing employee discount