Corp-Corp | View Job: NJ-Jersey City-Senior-DATABASE Administrator

View Job

Posted Date : Nov-06-09

NJ-Jersey City-Senior-DATABASE Administrator –SQL Server

DBAs; SQL Server DBA

SQL Server DBA, Windows, DTS, SSIS

Location	:	Jersey City, NJ
Domain	:	IT/Software,
Experience Level	:	Senior
Pay Rate	:	Market
Duration	:	3 Months

Preferred Work Authorization : US Citizen

Security Clearance

Green Card

EAD / TN

H1B Work Permit

Need H1B

Others

Preferred Employment : Corp-Corp

W2-Permanent

W2-Contract

1099-Contract

Contract to Hire

Need H1B

Primary Responsibilities:

Managing and administering SQL2000 and SQL 2005 databases, ensuring availability and performance of all SQL Server databases.
Managing the database space and allocation planning
Implementation of database and data architecture monitoring technologies and procedures and proactively monitor the database systems and resources to ensure secure, stable, high-performing services with minimum downtime.
Analyzing and reporting on metrics and trends.
Participate in the formulation of policies, procedures and standards relating to database management. Working with the teams in the design and implementation of database security policies and integrity controls.
Implementation of database backup and recovery technologies and procedures, as well as monitoring, testing and issue resolution.
Working with the development teams on projects and systems in database modeling and design, creating/tuning/optimizing indexes, stored procedures, DTS/SSIS packages and SQL jobs, as well as assisting in troubleshooting, performance tuning and general problem solving of SQL development.
Installation and configuration of SQL Server 2005/2008 databases on Windows 2003 Enterprise servers (32bit/64bit) in high availability environment, including reviewing, testing and implementing the database portion of third party software.
Performing all changes and maintenance of the databases, including rollouts and upgrades, as well as testing and approving SQL Server patching.
Participating in on-call support and managing SQL Server monitors and alerts.
Monitor and report on Golden Gate
Must be willing to work 10 pm to 6 am shift.

Experience

Candidate must be Microsoft Certified and possess self-motivation and strong communication and problem solving skills.
Experience of managing multiple MS SQL 2005 & 2008 RDBMSs (Standard and Enterprise Editions).
Knowledge of backups and recovery, security administration, database and server performance monitoring, tuning and trending, and capacity planning.
Experience with partitioning, file group optimization, database mirroring, log shipping, and clustering and expertise in SQL Server database replication is an absolute must!
Microsoft SQL clustering experience a must!
Hands-on experience with developing, optimizing and maintaining DTS and SSIS packages.
Relational data modeling and conceptual, logical and physical database design and implementation experience.
Experience designing and implementing data warehouses and data marts a plus
Experience working with distributed, scalable, highly-available architectures.
Experience with database modeling tools desirable.
Experience with data integration and ETL technologies desirable.
Experience with master data management tools and technologies a plus.
Experience with disaster recovery planning and implementation a plus.

Qualifications

6+ years experience supporting MS SQL Server as Database Administrator on SQL2000 and SQL2005.
4+ years experience with database modeling, stored procedures, jobs, complex queries and modifications.
4+ years experience programming in T-SQL.
4+ years experience troubleshooting database, system, and/or networking issues.
Golden Gate experience a plus.

Contact Details

Already a Member, Login

Post Resume to View Contact Details/Apply for Job

EMail ID:
Password:


	Contact Recruiter


	Quick Apply


	Forward Job


	Close

Contract Job details Corp-Corp

Post Resume to View Contact Details/Apply for Job