Intermediate Database Administrator

Continental Promotion Group, Inc. is the recognized leader in promotional fulfillment, having created consumer, retail and business-to-business programs for more than 500 national and international clients in 120 countries. Specializing in Rebate Fulfillment Services, CPG operates in a high-volume, transaction processing environment driven by state of the art technology. With offices in Florida, Arizona, Canada and Ireland, CPG is recognized as the global promotion services leader. For more information regarding CPG service offerings, please visit http://www.cpginc.com

 

CPG currently has an opening for an Intermediate Database Administrator.

Responsible for day to day (24x7) management of large-scale SQL 2000 Enterprise (30+ database servers) production, QA and development environment.

 

 

DUTIES/ RESPONSIBILITIES:

 Primary responsibilities include execution of developer-written SQL procedures & scripts. Assist development personnel in identifying performance-improvement opportunitiesEnsuring compliance with corporate coding standards is enforcedMaintain backups, transaction logs and log-shippingCreate, maintain and manage indexes. Assist development personnel in identifying index opportunities and enforcing standards and best practices of suchConstant scrutiny of existing processes and jobs to identify bottlenecks, potential scalability issues, general best practices and performance gainsResponsibility for documentation of configurations (server & DB), database design, disaster recovery procedures & scripts, rollback process for major releases, ERD, etc.Assist with performance tuning of existing DB processes as well as new features/implementationsEnsuring scalability and maintainability of 300+GB production environment

Growth position with opportunity to gain experience in large-scale database environment and quick-paced business environment. 2008 corporate initiatives include creation of corporate data warehouse and move to SQL 2005/2008.

 

 

QUALIFICATIONS:

 2+ years of focused database administrator duties in SQL 2000 environment, (2005 experience a plus)BS in Computer Science, Engineering or related field ( experience may substitute for degree)Exceptional written and verbal communication skillsAbility to interact with large development team (20+ developers located in Tempe, AZ and Tipperary, Ireland) and respond quickly and effectively while ensuring standards and best practices are enforcedProven experience writing and executing complex procedures, scripts, DTS/SSIS packages in n enterprise environmentComfortable with multi-database backup/restore/ recovery procedures within limited timeframesExperience/knowledge of Sarbanes Oxley, PCI Compliance & Disaster Recovery policy/procedure and best practices a plusExperience/knowledge in the following software packages a plus- Embarcadero DBArtisan, ER/Studio

 

To apply for this position, please send your resume in a Word document, along with your salary history and expectations to careers@ca.cpginc.com .

Please reference Intermediate Database Administrator  in the subject line.

 

CPG Inc. is an Equal Employment Opportunity Employer.

 

To all recruitment agencies: CPG does not accept agency resumes. Please do not forward resumes to our job alias. CPG employees or any company location. CPG is not responsible for any fees related to unsolicited resumes.