Job Description :
Experience and Skills:
Experience with SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc
Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling.
Experience in ETL Development using standard tools like SSIS, SSAS, or other open source ETL tools.
Knowledge of file and file transmission protocols (SFTP, Web Services, etc.
Strong knowledge of networking protocols and ODBC, JDBC connectivity as it relates to user based connectivity.
Knowledge of applications security including authentication and role based access control within the DB.
Robust data modeling and database design experience.
Strong adherence to source control, version management, or configuration management practices.
Ability to communicate effectively both verbally and in writing (clearly and succinctly
Experienced in providing ongoing maintenance and support of IT systems and User communities.
Capable of working independently or as part of a large team.
Experience in maintaining the confidentiality of sensitive information.
SQL Development – ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints
T-SQL, sqlcmd, bcp, sqldiag, tablediff and other programing and diagnostics - Expert level knowledge/experience.
Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Strong knowledge of Database server administration and in virtual environments.
Strong understanding of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of Database native tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system sprocs
Working experience of other advanced ETL tools is preferred (Informatics, Data Stage, CloverETL, Talend, etc.
Working knowledge Database Error and Exception Handling.
Knowledge of Base SAS programming and migration of SAS procs to SQL is a Plus.

Qualifications
Minimum 8 years of experience in developing TSQL code, and install/implement on production environments.
5+ years of experience in database architecture and administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR generation.
5+ Years of experience in implementing complex ETL processes.
3+ years of experience in database parameter tuning, data guard and golden gate.
Bachelor’s degree or equivalent work experience is required.
Experience in developing MySQL, Oracle, NoSQL (MongoDB, Cassandra etc database is a plus.
Strong adherence to source control, version management, or configuration management practices.
Experience in maintaining the confidentiality of sensitive information, including adhering to state, federal, and department privacy laws and regulations.
Exceptional analytical and problem-solving skills.
Ability to communicate effectively both verbally and in writing.