Senior Database Administrator

Enterprise OperationsUS Exempt RegularFull timeStateside Exempt 3.5Location: Adelphi, MD (Hybrid)

Summary:

The Senior Database Administrator's role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Duties and Responsibilities:

• Assess customer's business requirement and in conjunction with data owners and department managers develop long-term strategic goals for production databases (including MySQL, SQL Server, Mongo and Oracle).

• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.

• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

• Create models for new database development and/or changes to existing ones.

• Install and configure relevant network components to ensure database access as well as database consistency and integrity.

• Respond to and resolve database access and performance issues.

• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

• Monitor, optimize and allocate physical data storage for database systems.

• Plan and coordinate data migrations between systems.

• Develop, implement, and maintain change control and testing processes for modifications to databases.

• Create, or support creation of, required reports in response to business user needs.

• Perform database transaction and security audits.

• Establish appropriate end-user database access control levels.

• Develop routines for end users to facilitate best practices database use.

• Manage and/or provide guidance to junior members of the team.

Skills:

• Demonstrated 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

• Successful development and implementation of new technology and work processes

• Good written and oral communication skills.

• Strong technical documentation skills.

• Highly self-motivated and directed.

• Keen attention to detail.

• Proven analytical and problem-solving abilities.

• Ability to effectively prioritize and execute tasks in a high-pressure environment.

• Strong customer service orientation.

• 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 most cost-effective solution

• Ability to work with long-established senior staff, provide guidance, and assign and follow up on tasks

Education & Experience Requirements:

Experience:

• 6+ years in information technology.

• 3 years experience as a DBA in one or more environments.

• Experience with the following software languages:  MySQL databases, Mongo, Oracle Exadata, 11g Active Dataguard or other database replication technologies. Experience with Log Shipping, Database Mirroring for SQL Server databases. 

• Strong knowledge of Cloud (AWS, IaaS, SaaS, PaaS, DBaaS)

• Strong knowledge of SQL, and stored procedures & functions.

• Strong knowledge of MongoDB.

• Expert experience with setting up MySQL clusters, MySQL replication (Master-Master, Master-Slave, and cluster replication), MySQL backup, point in time recovery, and high available configurations in a complex and dynamic production environment.

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

• Mentor other DBAs in the team.

• Strong documentation and knowledge sharing skills.

• Experience working in a dynamic, 24x7 highly available work environment. 

• 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 with designing, building, installing, configuring and supporting database servers, including Oracle 11g OCA, 11g OCP, SQL Server 2008.

• Hands-on database tuning and troubleshooting experience.

• Experience with data processing flowcharting techniques.

• Project management experience preferred.

• Knowledge of applicable data privacy practices and laws.

• Strong customer focus and management of customer expectations; ability to establish and maintain a high level of user trust and confidence in IT's knowledge of and concern for users' business needs

Preferred Experience Requirements:

Education:

• Bachelor's Degree

All submissions should include a cover letter and resume.

The University of Maryland Global Campus (UMGC) is an equal opportunity employer and complies with all applicable federal and state laws regarding nondiscrimination. UMGC is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, ancestry, political affiliation or veteran status in employment, educational programs and activities, and admissions.

Workplace Accommodations:

The University of Maryland Global Campus Global Campus (UMGC) is committed to creating and maintaining a welcoming and inclusive working environment for people of all abilities. UMGC is dedicated to the principle that no qualified individual with a disability shall, based on disability, be excluded from participation in or be denied the benefits of the services, programs, or activities of the University, or be subjected to discrimination. For information about UMGC's Reasonable Workplace Accommodation Policy or to request an accommodation, applicants/candidates can contact Employee Accommodations via email at employee-accommodations@umgc.edu. 

Benefits Package Highlights:

• Generous Time Off: Enjoy 22 days of paid vacation, 15 days of sick leave, 3 personal days, and 15 paid holidays (16 during general election years). For part-time employees, time off rates will be prorated based on the number of hours worked.
• Comprehensive Health Coverage: Access to health care, medical with vision, dental, and prescription plans for both individuals and families, effective from the 1st of the month following your hire date.
• Insurance Options: Term Life Insurance, Accidental Death and Dismemberment Insurance, and Long-Term Disability (LTD) Insurance. Part-time employees working less than 0.5 FTE are not eligible for LTD.
• Flexible Spending Accounts: Available for medical and dependent care expenses.
• Retirement Plans: Choose between the Optional Retirement Program (ORP) or the Maryland State Retirement and Pension System (MSRPS).
• Supplemental Retirement Plans: include 401(k), 403(b), 457(b), and various Roth options. The university does not provide matching funds.
• Tuition Remission: Immediate availability for Regular Exempt Staff. Spouses and dependent children are eligible for undergraduate tuition remission after two years of service. NOTE: For part-time employees (at least 50 percent of the time), tuition remission benefits are prorated.

Hiring Range:

$117,000.00 - $127,900.00