Sr. Database Admin

Job Description -

(In person interview) so Local candidates only

Title : Sr. Database Admin (Lead prefered)

Location: – onsite in Trenton NJ Onsite 3 days, remote 2 days per week

Duration: 12 months

40 hours per week

– try to find someone with LEAD experience, lead database admin for example. 

Provides technical leadership for architecture, design, documentation and

maintenance of an internal database and related systems.

Please note that this is a hybrid role that requires an 

This role is critical for the project success and will be responsible to design, manage and

maintain the Relational/SQL databases, data warehouse, and reporting

infrastructure for all applications within DFD. 

General responsibilities include

Design, develop and maintain database solutions and data warehousing to support

enterprise application services, reporting and analytics, including architecture

design, data modeling, documentation, policies and standards.

Analyze system requirements and migration methods for existing data in legacy systems. Plan,

architect and optimize the data infrastructure to integrate with future systems.

Maintain legacy reporting as well as design and implement new reporting and data,

availability models.

Responsibilities:

• Design, implement and support data models,

databases, and DW solutions to meet the long-term goals for the DHS/DFD office. 

•Develop and implement OLTP schemas, comprehensive testing plans for validating

data transformation and integration, develop key metrics to ensure integrity on data

architecture. 

• Responsible to take the ownership for their assigned tasks and work

independently and deliver results in an iterative approach adhering to the sprint

deadlines.

• Must work collaboratively with the team of developers, Technical Lead,

Architect, Business SME’s, and Project Managers.

• Recognizes problems and

responds, systematically gathers information, sorts through complex issues, seeks

input from others, addresses root cause of issues, makes timely decisions, can

make difficult decisions, uses consensus when possible, communicates decisions to

others, and rapidly adapts to change. 

Required Skills: 

• Database modeling, architecture design, development, backup & recovery, and administration. 

• SQL Server scripting and programming in various platforms, detailed analysis and

design. SQL Server is required (Oracle and PL/SQL is a plus). 

• Experience in rapidly building new relational data models, tables, views, functions, grants, triggers,

stored procedures, indexes, and other database components to support the existing

& new development features in an agile environment. 

• SQL development (SSMS),Microsoft BI Stack (SSIS, SSAS). 

• Prior experience using various reports including SSRS (required) for report development. 

• Familiarity with developing Restful APIs for database layer, and web application architecture. 

• Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams. 

Nice to Have: • Knowledge/Experience in developing, hosting &

managing databases on AWS RDS. • Knowledge/Experience implementing

database designs, transactions for microservice architecture. 

• Experience in application modernization and migrating legacy platform’s data models (Mainframes

or similar). 

• Experience with GitHub, JIRA, .Net Core, EF core, Dapper, Data Lake,

Redshift, Docker/Kubernetes container services. Minimum Requirements: 7+ years

of Database design, SQL/TSQL development, SSMS, SSIS, SSAS & SSRS

experience. 1-2+ years on AWS RDS. Bachelor’s degree in Computer science or in

a related field.