Database Administrator - Network/Operations
At a glance
Mid-level Data Architecture & Governance role at Procom Consultants Group. Bala Cynwyd · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Keep development, QA and production environments aligned, then coordinate builds and releases between them
- Install patches, restart services and handle network changes and system-level checks
- Track CPU, memory and workflow loads, restarting failed jobs and investigating stalled sessions
- Maintain ODS, warehouse and data mart applications while conducting peer reviews and preparing technical documentation
What you bring
- At least four years of overall IT work and four years using Informatica PowerCenter
- Two years focused on ETL design, development, review and testing, plus data integration or warehouse environments
- Two years developing with SQL Server 2005, 2008 or 2012
- You can transform XML messages, work with XML schemas and optimize database queries
Who this fits
This contract role suits a mid-level database administrator with hands-on ETL and Informatica administration experience. The position is onsite in Bala Cynwyd, Pennsylvania, for a twelve-month assignment.
From the employer
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy
Specialties• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)
Database Administrator - Network/Operations
On behalf of our client, Procom Services is searching for a Database Administrator for a contract opportunity in Bala Cynwyd, PA.
Database Administrator - Network/Operations Job Details
Conduct peer reviews, and help prepare technical documentation, creation and maintenance of operational data store (ODS), data warehouse, and data mart applications. You will also coordinate builds and deployments across environments, and perform admin work as necessary. Responsible to manage Development ,QA and Production environments Making sure that code is sync in all the three environments. Patch installation (Hot Fixes /Software's ) Bouncing Activities or Restarting the Services Network Changes System level parameter checks CPU spike, Memory utilization Load Monitoring - Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
Job Responsibilities
• Responsible to manage Development ,QA and Production environments
• Making sure that code is sync in all the three environments
• Patch installation (Hot Fixes /Software's )
• Bouncing Activities or Restarting the Services
• Network Changes
• System level parameter checks CPU spike, Memory utilization
• Load Monitoring - Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
• Recovery or Re-start in loads in case of any failures.
• Identifying the tardiness in loading process in case of any sessions are in hung status.
Database Administrator - Network/Operations Mandatory Skills
• Minimum of 4 years of overall IT experience
• 2 years prior experience focused in ETL design, development, review, and testing
• 2 years professional experience in Data Integration/Data warehouse environments
• 4 years of experience with Informatica PowerCenter
• 2 years professional development experience in SQL Server 2005, 2008 or 2012
• Development experience in transforming XML messages and understanding of XML schemas
• Experience in database query optimization
• Integration experience with source code repositories (Subversion, Team Foundation Server).
• Experience working with offshore resources
• Experience working with vendors
• More than 2 years of experience in data warehouse/mart environments
• Experience building/implementing scalable, reliable, and high-performance ETL architectures
• Understanding of modern software engineering principles, practices, and systems development methodologies
• Excellent ETL design skills and hands-on experience in developing ETL mappings
• Hands-on experience in Informatica administration work
• Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings
• Working experience with insurance industry is a plus
• Professional experience with SAP Data Integrator as a designer and developer is a plus
• Strong Knowledge of the data governance and data management concepts and practices
• Strong Knowledge of the concepts, and best practices for ETL development
• High proficiency in understanding relational data models
• Advanced knowledge of XML, XSLT.
• Strong knowledge of Unit testing frameworks and SOAPUI
• Professional experience with SAP Data Integrator as a designer and developer is a plus
Database Administrator - Network/Operations Start Date
ASAP
Database Administrator - Network/Operations Assignment Length
12 Months
All your information will be kept confidential according to EEO guidelines. Please send your resume in Word format only.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.