12 days old

Senior Application Developer -- SQL - 175706

Chennai, TN 600003
  • Job Code
    175706

Position Summary:

We are looking for SQL Developer to design, analyze, develop, troubleshoot and maintain SQL stored procedures, databases and related utilities within the Celergo software environment. The SQL Developer will report to the Software Development Manager and will be accountable for creating SQL scripts and SSIS packages that improve and optimize database transactions within the Celergo Global Connect business model. In addition, the SQL Developer will be responsible for ensuring high data integrity as well as optimizing database performance within the environment.

 

Responsibilities

  • Perform complex database programming by writing SQL procedures on large-scale databases
  • Design and implement data solutions including data partitioning, data normalizing/de-normalizing, data aggregations, and ETL to support data warehouse environment
  • Work closely with our business teams to understand business reporting and analytic requirements
  • Develop new database schema/objects and/or review existing objects to improve storage efficiency and access
  • Creating, reviewing, analyzing, and modifying SQL scripts, procedures and supporting programs to ensure proper execution, efficient operation, and sustainable coding constructs.
  • Proven ability to perform technical troubleshooting to diagnose, isolate and correct data and database issues.
  • Conducting data analysis to identify data integrity issues within databases, interfaces, or other data related repositories.
  • Making design recommendations for database functions that meet business operating standards while improving the efficiency of business processes.
  • Applying quality controls to work functions including appropriate testing and validation of new or modified programs prior to deployment.
  • Demonstrating and applying reasonable and practical security controls within the SQL and database environments to minimize security risks.
  • Providing technical expertise in assessing software projects and related initiatives to enhance or support the Celergo software environment.
  • Writing technical procedures and/or supporting documentation for the applications including operational usage or procedures, user guides, etc.
  • Strictly adhering to programming / security standards or similar protocols that seek to reduce or eliminate risks associated with the introduction of program and/or data modifications.
  • Serving as a liaison and facilitator between departments to assist in addressing and resolving database related issues.

Qualifications

  • 6+ years of experience working with SQL Server
  • Must be able to create stored procedures
  • Strong knowledge and use of SSIS functionality for performing complex data integration functions.
  • Proven knowledge of SQL and relational database concepts including security and performance optimization.
  • Ability to develop and optimize data models including the use of effective/future dating logic.
  • Capability to write CLR assemblies for SQL Server is a plus.
  • Microsoft.NET, Excel VBA, and/or Visual Basic knowledge is a plus.
  • Strong analytical and problem solving skills.
  • Proven ability to be flexible and work hard, both independently and in a team environment, in a high pressure environment with changing priorities.
  • Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities.
  • Willingness to work occasionally outside of normal business hours.
  • Excellent English oral and written communication skills.
  • Experience with Accounting or Payroll environments is desired.

We're designing a better way to work, so you can achieve what you're working for. Consistently named one of the 'Most Admired Companies' by FORTUNE Magazine, and recognized by DiversityInc as one of the 'Top 50 Companies for Diversity,' ADP works with more than 740,000 organizations across the globe to help their people work smarter, embrace new challenges, and unleash their talent. "Always Designing for People" means we're creating platforms that will transform how great work gets done, so together we can unlock a world of opportunity.

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Categories

Posted: 2019-08-06 Expires: 2019-09-05

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Application Developer -- SQL - 175706

ADP
Chennai, TN 600003

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast