POSITION SUMMARY
Operates and maintains database environments. Duties include 24x7 support, change implementation and problem diagnosis. Responsible for ensuring team members meet delivery timeline. Mentors others and acts as subject matter expert for databases. Represents highest level of knowledge and expertise related to database technologies within BMI Information Services Group.

 LOCATION 
 Remote - (US)

 FUNCTIONS OF THE JOB
 Essential Functions: which may be representative but not all inclusive of those commonly associated with this position.

• Provides technical leadership, guidance and direction to other team members.
• Provides leadership during the development and enhancement of the enterprise’s production applications including working with applications, technical support and operations during the design, development and implementation of applications.
• Assigns technical tasks and responsibilities to appropriate team members.
• Implements database changes and identifies issues proactively to prevent outages with a goal of 100% uptime.
• Participate in application development projects to evolve database architecture and design.
• Designs schema changes and other components in tandem with team members and assess 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.
• Leads training for technical support and applications staff.
• Provides guidance to other IT departments concerning database related issues.
• 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.
• Leads recommendations for changing existing policy and procedures (changes, adds, removal).
• Works with database software vendors to resolve technical issues and plan for future enhancements.
• Oversees 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 Responsibilities.
• Regular attendance.
• Other duties as assigned.
• Supports our BMI Core Values and cultivates a culture of diversity and inclusion.

Specific Functions as Needed
 

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.

Oracle Database

• Provides production design, administration and support of large, 24x7 Oracle RAC 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 determining on call responsibility and unscheduled off-hour support.

POSITION QUALIFICATION REQUIREMENTS 
 Education: Bachelor’s Degree in Computer Science or Mathematics. Equivalent work experience as a DBA in a business environment may be considered

Experience Pending on Business Needs:

SQL Server Database

• Minimum seven 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 three 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 three 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 seven years experience with Oracle relational databases and high volume transaction processing systems, preferably in a custom software development environment, with at least 1 year in large data environment of 50 TB of data.
• Must have experience running under Linux, use of Oracle replication and back-up and recovery.
• Minimum two years of experience with Oracle 11g.
• Minimum three years of experience with Oracle Real Application Cluster (RAC).
• Minimum five years providing technical design, development and maintenance of Oracle databases in a high availability configuration.
• Minimum two years supporting C++ and JAVA environments.
• Minimum two years leading technical implementation teams.

DB2 Database

• Minimum seven 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 five years providing technical design, development and maintenance of DB2z database environment.
• Minimum two years leading technical implementation teams.

SKILLS AND ABILITIES 
Which may be representative but not all inclusive of those commonly associated with this position.

• Performance history of providing technical expertise with high levels of integrity and results.
• Experience as lead role and liaison with business and development teams.
• An expert level understanding of Relational Database Management System (RDBMS) fundamentals.
• Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is required.
• Experience with disaster recovery planning and implementation is required.
• Strong experience with data profiling, meta-data analysis, data modeling, and relational schema design is required.
• Expertise in 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 required.
• Demonstrable skills in database clustering, partitioning and replication.
• 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 Pending on Business Needs:

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.

DB2 Database

• Able to write and profile SQL and REXX. 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.Salary Range:

SALARY RANGE 
The specific base salary offered to a successful applicant will be based on individual qualifications, skills, experience, and education. The pay range is subject to change at any time based on various internal and external factors. The position may also be eligible for one or more performance-based bonuses. In addition to cash compensation, BMI offers a competitive portfolio of benefits to its employees, as described below.

What We Give to You:

• Health, dental, and vision insurance
• 401K with employer match
• Flexible spending accounts
• Paid vacation and paid sick/personal time
• 12 paid calendar holidays
• Paid volunteer time off
• Summer hours that offer more time for fun in the sun
• Company paid life insurance
• Up to 12 weeks paid parental leave
• Tuition assistance for qualified team members
• Commuter benefits (New York)
• Amazing and engaging culture
• Employee Resource Groups

BROADCAST MUSIC, INC. IS AN EQUAL OPPORTUNITY EMPLOYER: All applicants will receive equal opportunity for employment without regard of race, color, sex, religion, nationality, age, sexual orientation, gender identity and/or expression, veteran’s or marital status, disability, or any other cultural factor.

#LI-Hybrid