Principal Database Administrator
Liberty Corner, NJ

Job Description

Job Description

Everest Global Services, a member of Everest Re Group, Ltd., is seeking an experienced Principal Database Administrator (DBA) for its headquarters in Liberty Corner, New Jersey.

The responsibilities include but are not limited to:

* Create and maintain cloud-based Databases such as SQL Managed Instances, SQL PAAS, Azure Data Factory, Amazon Aurora, MongoDB, Cosmos DB, etc.
* Run a team of FTE, onshore and offshore consultant DBA's in a dynamic 24x7 environment.
* Installation, administration and maintenance of standalone and clustered SQL Server database instances in development, testing, staging and production environments
* Design state-of-the-art technical solutions that address requirements for scalability, reliability, security, and performance with a focus on database workloads on SQL Server.
* Work with the DevOps team integrating Databases into the CI/CD pipeline to ensure database deployments and implementation support efforts meet integration and performance expectations.
* Deliver on assigned database infrastructure related projects with participation through project lifecycle that includes new software releases, patch upgrades, prevention of feature exploitation, security and audit.
* Troubleshoot various problems that arise in day-to-day work. Independently analyze, solve and correct issues in real time and providing problem resolution end-to-end.
* Monitor and apply latest service packs for SQL Servers and apply Windows patches on SQL clusters.
* Manage database security by controlling database access permissions and privileges while complying with regulatory requirements.
* Design/Maintain a database backup and restoration strategy. Recover database to specific point of time per the requests or during outages.
* Proactive monitoring and performance tuning at the physical server level, database level and query tuning. Identifying and resolving production and application development problems.
* Refine and automate regular processes, track issues, and document changes.
* Establish and maintain best practices and operational procedures and generally provide guidance on SQL Server operation.
* Provide 24x7 support for critical production systems.
* Coordinate scheduled maintenance after hours as needed.
* Share domain and technical expertise, providing technical mentorship and cross-training to other team members.
* Install and test new versions of both on-premises and cloud-based DBMS.
* Writing/updating database documentation, including data standards, procedures and definitions.
* Stay abreast of architectural/ industry changes; especially in the areas of big data and the cloud.
* Meets with internal clients as needed to determine needs and/or identify problem areas

Work Experience and Qualifications

* Communication, teamwork and negotiation skills.
* Excellent problem-solving and analytical skills.
* Familiarity with the main data manipulation languages and the principles of database design.
* Excellent organizational skills.
* Ability to create and maintain strong working relationships with colleagues and customers.
* Ability to successfully handle multiple work streams across multiple engagements, while maintaining composure and professionalism to meet tight deadlines and shifting priorities.
* Innovative thinker who is positive, proactive and readily embraces change.
* Knowledge of and experience with the Azure Database Platforms.
* Degree in Computer Science, Information Technology or Business Administration or equivalent work experience (minimum 5 years).
* Expert Knowledge on SQLServer AAG (AlwaysOn Availability Group) and SQLServer FCI (SQL FCI).
* Should be skilled in designing a SQL Azure solutions and migrating on-premises data to cloud as well as Hybrid Azure Cloud experience hosting SQLServer both in-premise and in Cloud.
* Experience with the setup and configuration of Power BI (Power Query, Data Management Gateway).
* Experience with Dockers/Containers.
* DB2 administration knowledge is a must for this position.
* TDE encryption for SQLServer and DB2 databases
* Strong understanding of Business Intelligence concepts and best practices, with an understanding of its strategic importance to organizations.
* Superior conceptual and analytical abilities, identifying opportunities for improvement through analysis and creative thinking.
* 5+ years, recent experience developing solutions in a Microsoft SQL Server environment using SQL, stored procedures, functions and triggers.
* Expert knowledge of Microsoft SQL Server 2012 - 2019 Suite including (SSMS, SSIS, Query Profiler).
* Expert understanding of SQL Server security at both server and database levels
* Advanced knowledge and demonstrated ability in Query / Index tuning using Performance monitor statistics.
* Sound knowledge of database migration best practices for low risk and minimum downtime.
* Experience leading data migration projects.

Everest is committed to recruiting and retaining the most talented individuals in the industry. We offer a dynamic work environment and a competitive compensation and benefit package which includes a 401k plan, retirement/savings option, tuition reimbursement, medical, dental, vision, life and group legal plans.

Everest is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or creed, sex (including pregnancy), sexual orientation, gender identity or expression, national origin or ancestry, citizenship, genetics, physical or mental disability, age, marital status, civil union status, family or parental status, veteran status, or any other characteristic protected by law.

All considered applicants must be eligible to work in the U.S. with unexpired, acceptable employment eligibility verification documentation.