Senior Database Administrator, SQL

Position Summary:   The primary focus of the Senior Database Administrator - SQL is to provide and ensure consistent and reliable data throughout the Company?s relational database systems.  The DBA oversees the server installation, best practices and standards, security, database reviews and development, performance monitoring and maintenance and institutes, and monitors and tests database administration procedures including backup and recovery.  In this position the individual will lead in the design, creation and maintenance of interfacings with the development group to advise on database design and will also independently and effectively provide database solution and expertise on running company?s applications efficiently and cost effectively The SQL DBA also works with the user community by responding to special data needs and questions. 

 

Position Scope: Leads the SQL DBA in the administration and supports the company?s major Relational Database Management System platforms primarily Sybase, MSSQL, and Informix on UNIX and Windows Operating System hosted in Minneapolis for Dain?s Fixed Income, Private Client Group and Clearance & Execution Group businesses, which include branch office locations in thirty-nine states plus Washington DC and one hundred eighty correspondent investment firms (approximately 10,000 users). Accountable for the 7/24 Infrastructure Technologies production environment supporting trading floors in multiple locations.

 Major Job Accountabilities:

 

Production and Development Support (40%)

? Continously review standards and procedures for improvement, and ensure consistent application of these standards and procedures throught the company

? Provides support to application developers in the area of developing triggers and stored procedures.

? Prepares database implementation and data migration plan for production rollout

? Designs, develops, schedules and performs data archive jobs on production databases

? Ensures the efficient implementation and modification of database systems by developing and managing project plans, including schedules and budgets, and report variances from project plans/budgets with suggested corrective actions

? Implements database changes to production using RBC change management process

? Implements data models, and database design, data access and table maintenance codes

? Works with application support and system administration group to resolve database problems and issues

? Monitors Database Admin common mailbox for database related requests from application group

? Participates in Business Continuity Plan (BCP) tests, providing backup and recovery support

? Installs, configures, administrates and monitors to ensure 100% availability of development, user acceptance, production and recovery databases

? Develops, implements and maintains the integrity and security of databases including procedures for recovery and backup, protection against unauthorized access and supporting the Company?s regulatory-imposed security and confidentiality requirements

? Performs impact analysis for database changes to ensure smooth implementation on production environment

Project Support (40%)

? Manages database related tasks on projects that requires database environment

? Participates in design phase of the project to ensure that the database design is optimal and the project team follows database standards and best practices

? Helps project in vendor evaluation and capacity planning for database portion of the project

Relationships & Communication (10%)

? Effectively communicates and builds rapport with team members, other IT group in Dain and RBC including other geographies in order to implement efficient database system and follow best practices

? Facilitates small group meetings for database design discussion, enforcing database standards and knowledge transfer

? Resolves conflicts/issues and escalates others as appropriate

Development & Coaching (10%)

? Provides direction, expertise, feedback, coaching and development to build the capability of more junior staff

? Continually enhances skills and builds knowledge in all aspects of the organization, the business and information systems

? Performs other job related duties as assigned

 

Qualifications (Knowledge, Skills and Abilities)

Knowledge:

? Extensive knowledge and experience with Database Methodology, Database Management tools, current Database Standards, Data Modeling, Data Modeling tools, Meta Data Management, and Enterprise Data Integration

? Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques; ability to see the big picture and conceptualize and document creative solutions

? Strong working knowledge of SQL server job automation and data transformation using DTS packages

? Extensive knowledge of Transact-SQL language, stored procedures, triggers, views, query optimization, etc.

? Experience in designing, modeling, developing and supporting database systems

? Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files

? Experience in the designing of data extract, migration, and queuing facilities

? Proficiency in the concepts and practice of database normalization techniques

 

Skills:

? Team leadership and project management skills

? Strong customer service skills

? Strong written and verbal communication skills

? Strong problem identification and resolution skills

? Good research design, statistical and conceptual analytical skills

 

Ability to:

? Ability to be process oriented, focused on standardization, streamlining, and implementation of best practices

 

Minimum Requirements:

? College degree or equivalent work experience in computer science, or related area or equivalent work experience

? Five to eight years experience in designing and implementing relational databases

? Five to eight years experience of MS-SQL administration and MS-SQL database experience and technical support experience