Junior SQL Developer Software Engineer I-III

Position Description

Minimum 2+ years' experience. Develop high-quality SQL databases solutions and write the applications that interface with them including designing tables, store procedures, views, functions, forms, and reports to ensure their stability, reliability, and performance. Knowledge of all aspects of software development lifecycle SDLC. Maintain the SQL database. Help create and test SQL statements for data presentation and further automation. Setting up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures. Modify / update T-SQL scripts for importing and organizing data. Manage daily / monthly data and reporting processes automated through SQL Server agent. Work closely with analysts and other department personnel in advising best SQL coding practices. Create and manage data flow and data models for various systems. Provide troubleshooting and support for database instances in dedicated and multi-node clustered SQL Server environments. Participate in identifying stored procedure enhancements for database performance, reliability, and stability. Monitor systems and platforms. oversee backup, clustering, mirroring, replication, and failover. Respond to client requests for data by mining a data warehouse. Develop requirements from data requests and develop necessary SQL queries to produce output. Act as a liaison between the business units, technology teams, and support teams. Provide guidance to software engineers, architects and additional team members. Perform QA tests to ensure data integrity and quality. Review workflow charts developed by business analysts and programmers. Design and document database architecture using logical and physical data modeling tools and utilities. Run routine and ad-hoc queries as requested by the client. Conduct data exploration of new tables and schema in a data warehouse environment. Spend time contributing to conversations with leadership about the size and scope of your team. Participate in technical design and requirements gather meetings with clients. Provide effective and efficient solutions to complex business problems. Assist with mapping activities to assist with data normalization activities. Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity. Excellent attention to detail, ability to detect and correct problems within SQL scripts. Analyze the impact of change, anticipates possible problems, and develops plan to prevent them. Advocate and enable a philosophy for ongoing productivity improvement, reuse and education. Speak knowledgeably of relevant Software Engineering processes and management during client discussions. Estimate maintenance costs that are realistic, based on effort required, value delivered, and client's expectations. Work as part of a team or leads a team to negotiate new deals, extensions and ad-hoc service aspects. Recognize when alternative perspectives are required and facilitates appropriate meetings.

Requirements

Bachelor's or Graduate's Degree in computer science, engineering, information systems or information technology or equivalent experience.Experience with Microsoft Vista.Experience with SQL, SQL Server, Ssis, TSQL, ETL, PL/SQL, and SSAS software and systems.Experience with C#, C, Cloud, Oracle SQL, DMBS, UNIX, and JAVA software and systems.Fluency in scripting, Obiee, Olap, debugging and relational databases.Comfortable running analysis services.

Job Posted by ApplicantPro

Key Skills

• SQL
• C#