What are the responsibilities and job description for the Senior SQL Server Developer - Trenton, NJ position at Software Technology Inc.?
The Sr SQL Database Developer will be responsible for developing software and completing tasks as assigned as part of an Agile SCRUM team.
Tasks Will Include But Are Not Limited To
Tasks Will Include But Are Not Limited To
- Be involved and participate in the overall application lifecycle
- Main focus on coding and debugging
- Collaborate with Front-end developers
- Define and communicate technical and design requirements
- Provide training, help and support to other team members
- Build high-quality reusable code that can be used in thew future
- Develop functional and sustainable web applications with clean code
- Troubleshoot and debug applications
- Learn about new technologies
- Stay up to date with current best practices
- Conduct tests and optimize performance
- Manage cutting-edge technologies to improve applications
- Collaborate with multidisciplinary team of designers, developers, and system administrators
- Install, configure & manage new SQL Servers and databases (SQL Server 2017 or above). Managing multi DB environment setup (Including production).
- Extensive experience ensuring that all database servers are backed up and recovery is time tested to meet business's Recovery Point Objectives.
- Prior experience assisting developers with query tuning and schema refinement.
- Extensive experience writing Transact SQL (T-SQL) Queries, dynamic queries, indexes, constraints, views, functions.
- Extensive experience writing new and understanding/reviewing/fine-tuning existing Stored Procedures.
- Good command of Microsoft excel, data validations, data cleaning, manipulation,reporting and pivot features
- Extensive experience with failover clustering, replication, and other high availability technologies.
- Prior experience troubleshooting SQL Server service outages as they occur, monitor system's health and performance.
- Extensive experience working with developers to review scripts, and support frequent DB deployment activities.
- Prior experience with refinement and automation of regular processes, track issues, and document changes
- Experience with Azure SQL databases and Azure portal features.
- Good knowledge of XML and JSON Data structures.
- Experience with deployment tools like Red Gate SQL.
