The SQL developer role will interface with a team of platform and system developers while under the direction of senior development staff. Qualified candidates will have programming experience managing and processing large amounts of data and will provide summary analyses in written and oral presentation settings. You will also develop system test cases and documents results.

What you'll do:

• Development of high-quality database solutions
• Create complex functions, scripts, stored procedures, and triggers to support application development
• Translate regulatory requirements into technical requirements
• Creating and modifying tables within the database
• Testing to ensure data accuracy and functionality of the data collection tools
• Modifying database backend and web-based frontend designs
• Writing scripts for data processing/extraction
• Write complex queries to identify and export data
• Ensure data security including privacy protection, backups, etc.
• Translate and summarize data results into written reports, table, graphs, and charts to convey information to management
• Develop, implement, and optimize stored procedures and functions using SQL
• Review and interpret ongoing business report requirements and research required data
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements and suggest new queries
• Test and validate underlying report data
• Provide technical support, including training, to customers for existing reports.
• Develop procedures and scripts for data migration
• Provide timely scheduled management reporting
• Investigate exceptions with regard to asset movements
• Collaborate with internal and external development teams

 

What you need:

• Bachelor’s degree in computer science, Engineering, Information Systems/Technology or a related field
• 4 of years of experience as a SQL Developer or similar role with SQL Server Reporting Services and SQL Server
• 4 of years of experience with Transparent Data Encryption (TDE)
• C++/C# development experience preferred
• Strong quantitative skills, attention to detail, and a high aptitude for problem solving
• Proficient in standard business and database software including MS Office, MS Access, and SSMS
• Knowledge of the principles of data querying
• Excellent understanding of SQL programming
• Excellent understanding of Microsoft T-SQL Server
• Good knowledge of HTML and JavaScript
• Familiarity with the practical application of NoSQL\NewSQL databases

Posted On: Monday, October 4, 2021