Database Administrator
BMI
Nashville, TNThis was removed by the employer on 8/16/2017 2:12:00 PM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the IS/IT Category
Search for Database Administrator jobs in Nashville-TN
Search all Database Administrator postings
Full Time Job
POSITION SUMMARY: Operates and maintains all database environments. Duties include 24x7 support, change implementation and problem diagnosis. Serves as a resource in database technologies. Represents effective level of knowledge and expertise for databases within BMI Information Services Group.
FUNCTIONS OF THE JOB
• Implements database changes and identifies issues proactively to prevent outages with a goal of 100% uptime
• Involved in application development projects to evolve database architecture and design
• Designs schema changes and other components in tandem with team members and assesses potential impact to the production environment
• Works closely with other departments to ensure platform stability and optimal performance
• Designs and develops standards for production and test database administration activities
• Responsible for the creation of development, staging & production database instances and the migration of those application objects from one environment to another
• Responsible for all the performance tuning of the staging and production database instances
• Creates clear documentation of operating procedures, database object layout, work flow diagrams and specifications for developed databases
• Trains technical support and applications staff
• Provides guidance to other IT departments concerning database related issues
• Provides and designs tools and scripts to assist with data analysis, problem diagnosis, strategic planning and the management of the database and transaction processing environment
• Designs, implements, documents and monitors backup/recovery procedures
• Develops a methodology for the ongoing assessment of database performance and the identification of problem areas
• Develops a security scheme for the database environment, as well as assisting in disaster recovery
• Recognizes and identifies policy and procedure change management needs (changes, adds or removals)
• Works with database software vendors to resolve technical issues and plan for future enhancements
• Researches, tests and coordinates vendor supplied patches/upgrades
• Fulfills department requirements in terms of providing work coverage and administrative notification during periods of personnel illness, vacation or other absence
Specific Functions:.
SQL Server Database
• Provides production design, administration and support of large, 24x7 SQL Server database environment, determines on call responsibility and unscheduled off-hour support
DB2 Database
• Provides production design, administration and support of large, 24x7 IBM DB2z database environment, including on call responsibility and unscheduled off-hour support
Oracle Database
• Provides production design, administration and support of large, 24x7 Oracle RAC database environment including on call responsibility and unscheduled off-hour support
POSITION QUALIFICATION REQUIREMENTS
Education:
Bachelor’s Degree in Computer Science or Mathematics. Work experience as a DBA in a business environment may be considered equivalent.
Experience:
SQL Server Database
• Minimum five years’ experience with SQL Server relational databases and high-volume transaction processing systems, preferably in a custom software development environment with at least one year of large data environment of 50 TB of data
• Minimum two years of experience in system installation and upgrade, backup and recovery, data server migration, developer support, configuration and support of DTS and SSIS jobs, SQL Server Agent jobs and maintenance plans
• Minimum two years supporting of SQL and T-SQL, DDL, and DML
• Minimum two years experience in SQL Server 2008, 2012, 2014; SQL Server 2016 experience is a plus
• Azure SQL Server experience is a plus
Oracle Database
• Minimum five years experience with Oracle relational databases and high volume transaction processing systems, preferably in a custom software development environment, with at least one year in large data environment of 50 TB of data
• Minimum two years of experience with Oracle 11g
• Minimum two years of experience with Oracle Real Application Cluster (RAC)
• Minimum two years providing technical design, development and maintenance of Oracle databases in a high availability configuration
• Minimum two years supporting C and JAVA environments
DB2 Database
• Minimum five years experience with DB2z relational databases and high volume transaction processing systems, preferably in a custom software development environment, with at least one year in large data environment of 50 TB of data
• Minimum three years providing technical design, development and maintenance of DB2z database environment
Skills
and Abilities:
• Performance history of providing technical knowledge with high levels of integrity and results
• Understanding of Relational Database Management System (RDBMS) fundamentals
• Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is preferred
• Experience with disaster recovery planning and implementation is preferred.
• Eperience with data profiling, meta-data analysis, data modeling, and relational schema design is required
• Understanding of crossing platforms (e.g. – MySQL to Oracle), code migration, database change management and data management through the various stages of the development life cycle is preferred
• Experience using third-party database monitoring tools is preferred
• Strong communication skills; including ability to express complex technical concepts effectively, both verbally and in writing is required
• Ability to work well with people from many different disciplines with varying degrees of technical experience
• Expertise supporting the data repository needs of the IBM product stack
Specific Skills and Abilities:
SQL Server Database
• Able to write and profile SQL and TSQL. Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is required
Oracle Database
• Able to write and profile SQL and PL/SQL
• Experience with Postgres is preferred
DB2 Database
• Able to write and profile SQL and REXX