6 days old

Senior Database Developer - SQL Server

Princeton, NJ 08540
  • Job Code
    577064

One of our Philadelphia metropolitan area clients has an immediate need for a Senior Database Developer who will be responsible for building, support and maintaiinence of 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.


DUTIES/RESPONSIBILITIES



  • 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.
  • Configure and maintain SQL database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • 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.
  • 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.
  • 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.
  • Collaborates with project team members to identify issues and risks associated with the design, implementation, and delivery of project assignments.


TECHNOLOGIES:



  • Must have strong T-SQL coding skills, data modeling, understand Execution/Query Plans, transactionality and locking).
  • 5+ 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, SSRS and Power BI a plus


Tools:


Visual Studio 2012/2015, Erwin, VSTS for source code and defect tracking


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.

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

Senior Database Developer - SQL Server

Randstad Technologies
Princeton, NJ 08540

Share this job

Senior Database Developer - SQL Server

Randstad Technologies
Princeton, NJ
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast