SQL Developer
Job Posting for SQL Developer at Key Business Solutions, Inc.
SQL Developer
Albany, NY
24 Months
Job Description:
Department of Environmental Conservation needs a programmer to work on data architecture analysis, solution designing and providing ad-hoc support for Division of Environmental Remediation (DER) projects. Primarily staff will be responsible to design system architecture and writing complex stored procedures for a public facing online form submission application. DER also needs support for streamlining various legacy database processes for better data integrity, adhering to set OITS standards.
The SQL Programmer will be responsible for designing and maintaining MS SQL databases, reviewing database performance and optimizing existing processes. This individual will perform analytical and technical tasks to develop advanced complex SQL based solutions. This individual will also provide ad-hoc production support for the existing database needs.
• Building complex SQL queries, stored procedures, functions, views and reports.
• Understand the business needs effectively and work with the ColdFusion developers to design and draft modern and effective database architectures.
• Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages.
• Review performance logs to track and analyze production issues and optimize stored procedures for improved database responsiveness.
• Work closely with the database management team to establish database user provisioning and access management for the core applications.
• Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset.
• Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members.
Skill Matrix:
Regards,
Basha
Key Business Solutions, Inc.
|| Office: 916 646 2080 Ext 227 || Fax: 916 646 2081
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
Albany, NY
24 Months
Job Description:
Department of Environmental Conservation needs a programmer to work on data architecture analysis, solution designing and providing ad-hoc support for Division of Environmental Remediation (DER) projects. Primarily staff will be responsible to design system architecture and writing complex stored procedures for a public facing online form submission application. DER also needs support for streamlining various legacy database processes for better data integrity, adhering to set OITS standards.
The SQL Programmer will be responsible for designing and maintaining MS SQL databases, reviewing database performance and optimizing existing processes. This individual will perform analytical and technical tasks to develop advanced complex SQL based solutions. This individual will also provide ad-hoc production support for the existing database needs.
• Building complex SQL queries, stored procedures, functions, views and reports.
• Understand the business needs effectively and work with the ColdFusion developers to design and draft modern and effective database architectures.
• Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages.
• Review performance logs to track and analyze production issues and optimize stored procedures for improved database responsiveness.
• Work closely with the database management team to establish database user provisioning and access management for the core applications.
• Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset.
• Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members.
Skill Matrix:
| 1. | Minimum 60 months experience in designing advanced SQL queries, stored procedures, triggers, scripts, cursors and views | #of months | 20 |
| 2. | Minimum 60 months experience in MS SQL Server Management Studio | #of months | 12 |
| 3. | Minimum 60 months of experience in data modelling and designing data architecture | #of months | 12 |
| 4. | Minimum 48 months of experience in SQL code tuning, consolidating views and tracking database performance metrics | #of months | 12 |
| 5. | Minimum 48 months of experience in designing reports using either Crystal Reports or Business Objects XI or SSRS | #of months | 12 |
| 6. | Minimum 48 months of experience in designing and maintaining data dictionary and system documentation | #of months | 12 |
Regards,
Basha
Key Business Solutions, Inc.
|| Office: 916 646 2080 Ext 227 || Fax: 916 646 2081
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
Salary.com Estimation for SQL Developer in Albany, NY
$81,404 to $104,706
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
Sign up to receive alerts about other jobs with skills like those required for the SQL Developer.
Click the checkbox next to the jobs that you are interested in.
-
Backup/Recovery Skill
-
Income Estimation: $117,772 - $146,633
-
Income Estimation: $119,383 - $159,923
-
-
Brand Management Skill
-
Income Estimation: $59,130 - $78,984
-
Income Estimation: $65,068 - $88,298
-
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles
Skills Library
Job openings at Key Business Solutions, Inc.
Key Business Solutions, Inc.
Lansing, MI
Full Time
Key Business Solutions, Inc.
Atlanta, GA
Full Time
Key Business Solutions, Inc.
Lansing, MI
Full Time
Key Business Solutions, Inc.
Lansing, MI
Full Time
Not the job you're looking for? Here are some other SQL Developer jobs in the Albany, NY area that may be a better fit.
We don't have any other SQL Developer jobs in the Albany, NY area right now.
Dominion VUE / DMS, Albany, NY
Edward Daniels Group, Albany, NY