Previous Job
Previous
SQL Server Database Administrator (DBA)
Ref No.: 17-01520
Location: Brooklyn, New York
Client: New York City Employees' Retirement System ("NYCERS”)
Work Location: Brooklyn, NY
Duration: 12 Months (+12 months extension)
Interview: face to face
Required: 2 Candidates



Job Description:
Responsibility:
The SQL Server DBA shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing effort  as well as NYCERS' ongoing process improvement programs. The following  deliverables shall apply:
  • Provide technical support to NYCERS data integrity and quality initiatives
  • Recommend and support processes to proactively detect, correct, and prevent invalid data values.
  • Identify database requirements by interviewing applications and operations.
  • Develop and maintain database objects.
  • Maintain database lifecycle management processes and provide impact information on proposed changes.
  • Install new systems and recommend optimum access techniques.
  • Support database performance and optimization tuning, reorgs, backups and export/imports.
  • Database Security, Promotion of Process Improvement and Information Security Policies.
  • Collaborate with data SME's and technical leads in identifying and addressing data quality gaps
  • Work with IT partners to remediate identified gaps using both manual and automated solutions
 
Mandatory Skills:
  • Must have excellent interpersonal, communication, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities of RDMS.
  • Minimum of five (5) years of experience as a functional DBA maintaining SQL Server databases, performance tuning by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
  • Deep knowledge of T-SQL development and auditing of complex queries for optimal performance and improvement recommendations.
  • Experience installing, configuring and maintaining SQL server databases running on MS Windows Server.
  • Experience managing database security and user permission and privileges in accordance with application and database requirements.
 
Preferred Experience:
  • Experience with Data Quality tools (IBM Information Server or Informatica Data Quality)
  • Experience with multidimensional Data Warehouses is a plus
  • Working knowledge of UDB or DB2 LUW is a plus
  • Experience migrating VSAM data to relational databases
  • Experience in Data Modeling is a plus
 
Note:
Need to fill Skill Matrix
2 References Required

Mandatory Qualifications
Skills and Experience Provide Dates and Company Name where the you have demonstrated the qualification or identify how you meets the requirement
Must have excellent interpersonal, communication, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities of RDMS.  
Minimum of five (5) years of experience as a functional DBA maintaining SQL Server databases, performance tuning by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.  
Deep knowledge of T-SQL development and auditing of complex queries for optimal performance and improvement recommendations.  
Experience installing, configuring and maintaining SQL server databases running on MS Windows Server.  
Experience managing database security and user permission and privileges in accordance with application and database requirements.  

 





















Preferred Experience
Skills and Experience Provide Dates and Company Name where the you have demonstrated the skill
Experience with Data Quality tools (IBM Information Server or Informatica Data Quality)  
Experience with multidimensional Data Warehouses is a plus  
Working knowledge of UDB or DB2 LUW is a plus  
Experience migrating VSAM data to relational databases  
Experience in Data Modeling is a plus  
Experience in Pension Systems is a plus  
 
Reference 1
Company Name  
Company Address  
Reference Name & Title  
Reference Phone Number  
Reference Email  
Brief description of the project the resource completed.  
 
Reference 2
Company Name  
Company Address  
Reference Name & Title  
Reference Phone Number  
Reference Email  
Brief description of the project the resource completed.