The Database Administration Manager reports to the Director of Systems Integration and is responsible for the planning and management of all technical and operational activities associated with the database administration function. This individual oversees administration of relational database management system (Oracle/MS SQL),and object-orienteddatabase management system (Cahce) data, as well as data spaces in one or more computing environments (e.g., Unix, Linux, Windows). Manages a team of database specialists responsible for the technical functions associated with creating and maintaining databases: high availability; performance and tuning analysis; capacity planning, workload modeling, and prediction; systems support; long-term strategic planning; application support and optimization; problem resolution tracking; and software upgrades. Ensures high-level support for a large and complex RDBMS/ODBMS environment consisting of more than 350 database instances.
Responsibilities
Manage a team that assists with the design, development, preparation, and maintenance
of databases
* Problem resolution tracking: Ensure data pertaining to the status of problems and service requests is entered into problem tracking systems accurately and promptly
on a daily basis; provide an up-to-date picture of service delivery status and backlog
* Software upgrades and planning: Establish a schedule for upgrades of the RDBMS environment with current stable versions of software products; maintain currency with operating system and support software; plan and implement major software upgrades; ensure change management procedures and methodologies are implemented and followed
* Oversee production support issues
* Manage a team of database administrators that ensures first-level application support: Provide management oversight of problems and issues pertaining to the RDBMS and platform operating environment (e.g., Unix, NT, OS/390); facilitate application development and client problem resolution with optimum speed and efficiency
* Manage the group responsible for RDBMS performance monitoring and tuning: Closely monitor performance, identify problems and implements solutions, and ensure the database is running at optimum speed and efficiency
* Ensure that database backup/recovery environment responds quickly to refresh data, verify implementation of correct backup strategy, develop recovery procedures, and support recovery from loss of data caused by user or system error
* Oversee Installation and upgrade of RDBMS and related products: Keep RDBMS at current release and maintenance levels, install supporting products, and provide current, stable production and development environments
* Reorganize database structures as needed: Automate procedures at regular intervals;
use tools to reorganize or de-fragment database table spaces, tables, and indexes; and provide an efficient database environment to maximize productivity and improve performance
* Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including exporting, dropping, creating, and importing prescheduled time to minimize impact; and provide to application development staff an optimal development environment with current data
* Provide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff; and standardize environment and improve efficiency
* Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; and optimize space allocation and avoid out-of-space conditions
* Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance; ensure that proper data modeling and design paradigms are applied
* Work closely with Senior Systems Programmers * RDBMS to create database schemas and subschemas, lead/review database designs, and estimate sizes of new databases
* Develop and oversee rules, procedures, and standards for the access and maintenance of shared data resources
* Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
* Communicate complex technical information in a concise and articulate manner
* Participate in the evaluation and recommendation of DBA tools and new DBMS technologies
* Serve as business liaison to database vendors
* Ensure the integrity of production test and quality assurance database environments
* Ensure that impact analyses, research products, software configuration parameters, and standards and procedures support the company*s database environment needs and are adhered to by database administration staff
* Oversee application-oriented database administration and technical support for the various development, training, testing, and production requirements of relational database environments; focus on application-specific database issues to ensure optimal
application performance and integrity
* Oversee development of utilities for monitoring and evaluating data quality
* Review application transaction volume and traffic analysis, and interpret impact on database and network performance
* Interact with analysts and developers for development projects to understand system requirements of conceptual models, analyze transactions and data volumes, and design
the physical database
* Manage and develop technical project plans for new activities
* Establish and maintain policies, procedures, and standards to ensure systems compliance
* Conduct logical data analysis, design, and implementation for new client production databases
* Analyze, design, implement, and recommend solutions to meet organizational needs
* Oversee database operations to ensure availability and optimal performance
* Manage backup and disaster recovery procedures
* Prepare status updates and progress reports for all database-related projects
Skills and Knowledge
* 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
* First-hand prior experience in designing, modeling, developing, and supporting large RDBMSs (or ODBMSs)
* Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology, and also physical schema design of table
spaces, rollback segments, and data files
* Experience in the design of data extract, migration, and queuing facilities
* Proficiency in the concepts and practice of database normalization techniques
* Strong working knowledge of state-of-the-art database concepts/design/deployment, recovery techniques, performance monitoring and tuning, Structured Query Language,
relational database design techniques, and high availability technology * Ability to monitor and tune the database
* Good knowledge and understanding of server-side development issues surrounding triggers, stored procedures, and packages
* Strong customer focus and capabilities in managing client expectations; ability to establish and maintain a high level of user trust and confidence in the IT group*s knowledge of and
concern for users* business needs
* Excellent oral and written communication skills
* Ability to present and explain technical information to diverse types of audiences (management, users, vendors, technical staff) in a way that establishes rapport, persuades
others, and gains understanding
* Ability to write clear proposals and technical documents
* Strong interpersonal skills at all levels of management and ability to motivate employees/teams to apply skills and techniques to solve dynamic problems; excellent teamwork skills
* Solid project management skills, effectively managing multiple small to large projects in a cross-functional environment
* Ability to weigh various suggested technical solutions against the original business needs and choose the best overall solution
* Experience in hiring and management of a team of database specialists, including the ability to work with senior staff, provide guidance and mentoring, and assign tasks
* Proficiency in several RDBMS-specific middleware tools and utilities to support such activities as monitoring, database migration, DDL (data description language) management,
and replication
* Experience with cross-platform networking in a TCP/IP environment
* Full knowledge of SQL, including programming and ways to optimize SQL code
Experience
* Bachelor*s degree in Computer Science, Engineering, or related discipline; Master*s degree is desirable; equivalent experience acceptable
* Minimum of eight years of experience with information systems in a complex multi-platform healthcare environment
* Minimum of three-five years of experience in a supervisory/managerial role responsible for technical teams and successful execution of database-related projects with enterprise impact
* Hands-on experience in a 24x7 support environment, including tuning, load balancing of databases and applications, clustering, backups/restores, and troubleshooting
* At least five years of in-depth experience in the design, administration, programming, and support of RDBMSs/ODBMSs (e.g., Oracle, MS SQL, Cache) in one or more computing environments (e.g., Unix, Windows, Linux)
* Minimum of five years of experience as a DBA in one or more environments is highly desirable (preferably with RDBMSs and ODBMSs), or strong, demonstrated DBA skills earned in equivalent experience
* Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex environments
* Highly desirable that this individual has demonstrated two or more of the following:
* successful experience managing a multidiscipline, high-performance work team or project group
* competency in project management and management of resources to meet goals and multiple projects
* successful experience in working with end users to develop effective solutions to diverse and complex business problems
* initiative, good judgment, and the ability to achieve results through others
* success in developing and implementing new technology and work processes
