Database Administrator- Application Support with ETL/Teradata
|Date Posted:||October 8, 2014|
As part of the Client Technology Services Group, this person will be responsible for the full systems development lifecycle from requirements gathering through implementation of various functional architecture solutions. This person will work closely with our clients and must demonstrate individual functional and professional knowledge to ensure that the work products and deliverables are of the highest caliber to ensure client satisfaction. This person will also apply project management expertise to identify, develop, and implement techniques to improve engagement productivity, increase efficiencies, mitigate risks, resolve issues, and optimize cost savings and efficiencies. Technology Experience with various ERP functional solutions architecture Experience with system design, configuration, customization, integration, testing and support Experience with all aspects of the system implementation including, but not limited to, gathering requirements, designing the future state solution, the development objects related to their process scope, as well as supporting testing and post implementation support Knowledge of integration points and the order in which these must be executed Experience working with design, implementation, and support of knowledge management solutions and related technologies for collaborative information sharing Experience with gap analysis and strategic roadmap/blueprint development Experience with large Full Life Cycle (FLC) project implementations ERP certification(s) preferred Delivery Experience within a delivery role Experience with client facing consulting engagements Extensive experience within management consulting or consulting services (Big 4 preferred) Soft Skills Excellent analytical and problem solving skills Excellent verbal and written communication skills Strong executive presence and ability to interact with CxO level Mentors team members in technology, architecture and delivery of applications Successful teamwork experience and demonstrated leadership abilities are required Creates a shared sense of direction and community among the teams Proven ability to transfer knowledge and stay aware of current trends and technical advancements Ability to articulate and present different points-of-views on various technologies Time management skills are a must; as well as the ability to be flexible and creative MUST be willing to travel extensively, up to 100% College degree in a related area of study, with advanced degree highly preferred A strong track record of professional success, preferably in the Consulting Services arena ROLE RESPONSIBILITIES: Participate in system documentation, testing, implementation, maintenance, and project setup/support often involving performing project setups, analyses, and designs. Plan and execute support projects to improve and streamline processes. Assist in determining the impact of operational issues and provide input into their resolution via data extraction and quantification Coordinate and prioritize all escalated activities, including testing, project management and implementation of system upgrades, enhancements, and bug fixes. Assess critical path and assist in implementation of any project required by the business Resolve day-to-day support issues ensuring effective and timely resolution Provide 24/7 on call support Interpersonal communication and documentation skills Interface with database administrators and developers to keep abreast of the evolution of management system(s) used to create the reports from which relevant information is analyzed and/or distributed. Assist with the deployment of hardware and software to include activations, de-activations, changes, inquiries and adjustments. Identify sources and trends of technical problems to prevent future occurrences. Work with Development team and solution architect to understand project requirements and support project deployment. Transfer knowledge to other members of your team as well as across to other groups. Assist in testing of new software as escalated. Resolve conflicts and trace errors Take ownership of the issues, through root cause analysis and resolution Develop solid relationships with infrastructure/operational teams and leverage the relationships to improve system stability and availability Required Skills and Experience (Strong focus on ETL/Teradata) 5+ years experience with the following technologies RDBMS (Teradata, Oracle, SQL Server) Experience working with Oracle on Unix using command line and GUI SQL tools required ETL Tools (Informatica, SSIS, etc.) Reporting (Business Objects), Analytic and OLAP tools Telecommunications experience required (2 to 4 years preferred). System Analysis experience in the support/operation of a of large carrier class enterprise software system, preferably in a wireless environment Experience in testing, quality and change management methodologies required. ROLE RESPONSIBILITIES: Work with business teams and technical analysts to understand business requirements Design best practice data integration solutions for multiple projects Research source system architecture Determine the most effective method of data acquisition Work with the system owners and developers to implement the solutions Participate in the design and implementation of new ETL hardware and software platforms Help to develop reusable ETL processes and mappings within Informatica Lead Solution Architects and developers in creating an end to end integration solution Create and maintain best practices and ETL development standards Participate in the upgrade and migration of legacy ETL platforms to a new data center Create architecture and technical designs for development teams Create source to Client mapping documents to implement business logic and transformations Create logical and physical data models based on the business reporting requirements Work with development, infrastructure, test, and production support teams to ensure proper implementation of solution Required Skills and Experience: 6-8 years of experience in following: Must have experience with RDBMS (Teradata, Oracle, SQL Server) Must have experience with data modeling tools (ERWIN or ER Studio) Must have experience with Unix and Windows operating systems Must have experience with ETL Tools (Informatica, SSIS, etc.) Must have experience with Reporting, Analytic and OLAP tools (Business Objects) Nice to have experience with Management tools (SAP, Varicent, etc) Nice to have experience with Infrastructure components including server configuration, SAN, NAS, and networking Expert Knowledge of Informatica PowerCenter (6 years or more) current on v8.6.1 or 9.01 Expert Knowledge of Database technology; Oracle and Teradata Expert Knowledge of Middleware and SOA Technologies; Tibco and Weblogic required Expert Knowledge of network topology, switch and routing, design efficiencies. Expert Knowledge of systems Security technology.
Other jobs you might like