We are seeking a SQL Server DBA - contract to hire - for our client in Fort Lee, NJ. Position is third shift 10:00 PM - 6:00 AM. This SQL Server DBA primary responsibilities are:
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
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
Please contact:
Virginia Brewster
Senior Recruiter
TECHNISOURCE
100 Wood Ave. South, Suite 208
Iselin, NJ 08830
732-623-5932 Office 732-549-1453 Fax
virginiabrewster@technisource.com
