Job Description :
Title: Database Developer

Location: NJ

Position Type: Fulltime Permanent

Salary: DOE

Job Summary

Responsible tobuilding, support and maintain a highly available, efficient
and secure SQL database environment, including database design, coding,
testing, debugging, and requirements documentation at a mastery
level.Ensures application database design, development schedule, and
implementation meet or exceed documented application scope/timeline, while
adhering to established standards.Works closely with architects, application
developers and operational teams during database architecture review and
design considerations in effort to build a logical database environment that
meets current and future business objectives.

Illustrative Duties and Responsibilities

1.
Create tables, views, stored procedures, indexes, SSIS packages, and SQL
Agent Jobs in SQL Server and Azure SQL DW to support ETL processing and end
user reporting. Apply data modeling techniques to ensure development and
implementation support efforts meet integration and performance
expectations.
2.
Configure and maintain SQL database servers and processes, including
monitoring of system health and performance, to ensure high levels of
performance, availability, and security.
3.
Performs technical design and maintain documents technical specifications.
Assists application architects in the creation of application, integration,
and data architecture.Assist with documenting data flow processes and
database objects, monitoring of ETL jobs and troubleshoot as needed,
monitoring and tuning database performance, maintenance and design of the
data model and the data dictionary.
4.
Reviews other developers work against high standards of quality and
technical excellence (using best practices) to ensure solutions are aligned
to architectural specifications and design. Investigates and corrects
reported issues against existing software. Recommends performance
improvements including tuning, or process changes. Has an advanced
foundation in designing and developing for non-functional requirements
including reliability, availability, and performance, scale, security, and
data integrity.
6.
Strives for personal and organizational improvement - passionate about
making sense of information to suggest new possibilities for improvement and
pushing those ideas forward; seeks out new experiences, knowledge, and open
to learning and change.
7.
Collaborates with project team members to identify issues and risks
associated with the design, implementation, and delivery of project
assignments.

RequiredTechnical Skills

Prefer computer science background with strong understanding of writing
maintainable, performant systems.
Development Methodology: Agile/Scrum

Technologies:

Must have strong T-SQL coding skills, data modeling, understand
Execution/Query Plans, transactionality and locking5+ years of SQL
Developer experience creating databases, tables, views, functions, stored
procedures, and indexes. Must have experience working with Azure SQL
Database and/or Azure SQL DW.Strong experience in monitoring and tuning MS
SQL Server databases for optimum performance and assistance in capacity
planning of database servers. Strong understanding of database structures,
normalization, principles and practices.Experience analyzing data
requirements, defining DB architecture, documenting technical design,
testing databases, and proposing solutions that meet an organization''s
enterprise frameworks, standards, and best practices.
Must have experience writing unit tests and experience with source control
management and defect tracking systems, such as Microsoft Team Foundation
Server, Git.

Must be able to operate with minimal oversight and operate within a
self-organizing scrum team.

Experience with Azure DocumentDB, SSRSand Power BI a plus
Tools: Visual Studio 2012/2015, Erwin, VSTS for source code and defect
tracking

Required Licenses, Certifications, and Other Requirements
Nice to have Microsoft developer certification

Education & Experience

Minimum of Bachelor''s Degree; Minimum of 4-5 years of applications
development experience in a fast paced web project leveraging above
mentioned technologies; Must appreciate team work, collaboration and
continuous improvement as core tenants of their work; understanding of
methodologies and delivery of business software solutions with experience in
the various SDLC methodologies and working with a DevOps mindset.