Company: Uniqsoft Inc
Location: Jersey City
Posted on: July 13, 2018
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.
Keywords: Uniqsoft Inc, Jersey City, Database_Developer, IT / Software / Systems, Jersey City, New Jersey
Didn't find what you're looking for? Search again!