Database Administrator 4
About The Position
Database Administrators maintain and provide technical support for the database and reporting environment. This is an expert, architect-level role with responsibilities including strategic planning, solution design, database security, performance management, capacity management, operational procedures, and disaster recovery planning. The role also involves leading efforts with developers, IT technology teams, and business partners to support current and future enterprise strategic objectives, as well as leading and managing efforts with vendors and consultants to evaluate and implement new technology. The Database Administrator will serve as a subject matter expert to support developers, business partners, and other stakeholders throughout application development initiatives. Responsibilities include designing and implementing reporting solutions, developing transaction processing environment models, developing and implementing database security policies and procedures, developing and implementing processes and tools to monitor database operations and performance, developing and implementing database disaster recovery strategies, migrating legacy database implementations to enterprise standards, performing code reviews of SQL scripts, managing and monitoring SQL server database backup and recovery processes, and designing, implementing, and managing Microsoft SQL server installation and operational processes. The role also involves executing test procedures for software debugging and performance tuning, collaborating with other IT professionals to resolve software defects, monitoring ETL loads, leading and participating in daily stand-up meetings and SCRUM activities, supporting enterprise change management processes, and documenting project requirements and specifications.
Requirements
- 10+ years IT experience.
- 7+ years recent MS SQL Server DBA experience on W2K servers
- Advanced SQL Reporting Services experience
- 2-4 year college or university degree in software engineering, computer science or equivalent work experience.
- Operates a computer most of the day.
Nice To Haves
- Microsoft PowerShell
- Oracle
- MySQL
Responsibilities
- Serve as Enterprise Architect for database technology and data reporting solutions.
- Provide 3rd level technical support for the enterprise database and reporting environment.
- Lead efforts with developers, IT technology teams and business partners to support current and future enterprise strategic objectives.
- Lead and manage efforts with vendors and consultants to evaluate and implement new technology.
- Serve as subject matter expert to support developers, business partners and other stakeholders throughout application development initiatives.
- Design and implement reporting solutions to meet business partner requirements, including data models, dimension tables, etc.
- Develop transaction processing environment models for capacity planning and performance management programs.
- Develop and implement database security policies and procedures.
- Develop and implement processes and tools to monitor database operations and performance.
- Develop and implement database disaster recovery strategies, tools and procedures.
- Work with business partners to migrate legacy database implementations to enterprise standards.
- Perform code reviews of SQL scripts submitted through Team Foundation Server (TFS) Release Management.
- Manage and monitor all SQL server database backup and recovery processes.
- Design, implement and manage all Microsoft SQL server installation and operational processes, including performance tuning and patch management procedures.
- Execute test procedures for software debugging and performance tuning purposes.
- Collaborate with network administrators, systems analysts, programmers, and other software engineers to resolve software defects in company systems.
- Monitor ETL loads for core banking and enterprise data warehouse systems.
- Lead and participate in daily stand-up meetings and SCRUM activities.
- Support and promote enterprise change management processes.
- Research, document and implement project requirements and specifications.
- Document all processes and standards.
- Work closely with Database & Development Manager to monitor and manage work queue to meet deadlines and business partner expectations.
- Assist Database & Development Manager with workload prioritization, resource assignments and staff communications.
- Train, mentor and develop DBA staff and other IT team members, including back-up resources for enterprise database functions.
- Identify process improvement opportunities and develop solutions.
- Attend meetings as directed by Database and Development Manager.
Benefits
- 15% annual bonus target (with potential for higher payouts based on company performance).
- Potential long-term incentive (LTI) awards for high performers.
- Pension program with a 5% annual allocation.
- Wellness programs and other banking-industry benefits.
- Additional bank holidays and paid time off compared to many employers.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
