On behalf of our client, Procom Services is searching for a Database Administrator for a contract opportunity in Bala Cynwyd, PA.
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.
- Responsible to manage Development ,QA and Production environments
- Making sure that code is sync in all the three environments
- System level parameter checks CPU spike, Memory utilization
- Load Monitoring
- Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
- Identifying the tardiness in loading process in case of any sessions are in hung status.
Database Administrator
• Network/Operations Mandatory Skills
- 2 years prior experience focused in ETL design, development, review, and testing
- 2 years professional experience in Data Integration/Data warehouse environments
- 2 years professional development experience in SQL Server 2005, 2008 or 2012
- Development experience in transforming XML messages and understanding of XML schemas
- Integration experience with source code repositories (Subversion, Team Foundation Server).
- 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
- Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings
- 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
- Professional experience with SAP Data Integrator as a designer and developer is a plus
Database Administrator
• Network/Operations Assignment Length