Principal Database Administrator - Liberty Corner, NJ - Georgia IT Inc.
Liberty Corner, NJ
About the Job
Principal Database Administrator
Location: Liberty Corner, NJ
Position Type: Full Time
Rate: Salary + Benefits
Responsibilities:
Work Experience and Qualifications
Location: Liberty Corner, NJ
Position Type: Full Time
Rate: Salary + Benefits
Responsibilities:
- 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.
- Install and test new versions of both on-premises and cloud-based DBMS.
Work Experience and Qualifications
- Always on availability Group Encryption
- Various HA/DR Solutions
- Handle offshore
- Provide 24x7 support for critical production systems.
- Azure SQL
- Performance optimization
- BCP
- Coach & Mentor
- SQL server 2012 thru 2017
- SOX Audit
- Installation & Patching SQL server FCI
- 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
- 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.
Source : Georgia IT Inc.