Database Developer

ESSENTIALS ROLES AND RESPONSIBILITIES Perform analysis, code, testing and implementation of SQL procedures, functions, and other database development objects. Collaborate and integrate with other team members and third-party companies. Prepare business documentation regarding databases and SQL development, such as functional and detail design documents, configuration documents, ER diagrams, and so on. Perform Data architecture analysis and design. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Develop SQL Data transformation and optimization processes. Ability to create, troubleshoot, and modify SQL procedures, such as DTS, SSIS, SSRS, or other ETL tool is required. Perform SQL code reviews and implement best practice coding standards for SQL coding. Perform Production and Development Database administration activities, such as upgrade, backup, recovery, migration, etc Ensure that databases perform at optimal conditions performing preventive and reactive actions in a timely manner to incidents. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes. Assist other developers with complex query tuning and schema refinement. Participate in on-call rotation to provide 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. TRAINING & EDUCATION Bachelor's Degree in Computer Science/Engineering or equivalent work experience. PROFESSIONAL EXPERIENCE 3 years of databases development experience. 2 years of experience working with Business Stakeholders within a Cross-Functional matrix environment. Demonstrable experience in .Net technologies: VB, C#, Visual C++, ASP; Web-services, SOAP and XML objects; IIS5, SAAS - JavaScript, CSS, AJAX, SSIS and Reporting Services. Demonstrable experience in MS SQL Server technologies applied to large databases.