Database Administrator- Application Support with ETL/Teradata

Apply Now
Company: Compnova
Location Atlanta, GA
Date Posted: October 8, 2014
Source: Compnova
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

  • Sr Oracle Database Administrator

    T-Mobile

    - Atlanta, GA

    Job Description: Database administration position involving Configuration, Administration, Monitoring, Security Management, Performance Tuning, Backup/Restore and ...

    13 days ago from T-Mobile and MetroPCS
  • Product Specialist, Master Data Management

    Informatica

    - Atlanta, GA

    Job Description Our Company Everything Informatica does begins and ends with data. Simply stated, we make great data – data that is connected, clean and safe - ready to ...

    12 days ago from Informatica
  • Sr Manager, Database Administration-Teradata

    T-Mobile

    - Atlanta, GA

    Job Description: Provide senior leadership and management for the supported department. Position is responsible for database installations and upgrades, backups and ...

    11 days ago from T-Mobile and MetroPCS
  • Oracle DBA

    Principle Solutions Group

    - Atlanta, GA

    Senior Oracle DBA Our client located in the metro Atlanta area is looking for a Senior Oracle DBA that has good design, installation, and configuration and troubleshooting of ...

    30+ days ago from Principle Solutions Group
  • VP Data Centre

    ExecuNet

    - Atlanta, GA

    PURPOSE To lead and drive the global Technical Development organisation, managing the design, development and lifecycle of global IT & Communication products and ...

    6 days ago from ExecuNet
  • Manager, Database Administration SQL Server

    T-Mobile

    - Atlanta, GA

    Job Description: Manager, Database Administration SQL Server Provide senior level leadership and direction to Database Administration - SQL Server team. Provide tactical ...

    13 days ago from T-Mobile and MetroPCS
  • Oracle Database Administrator

    NEW

    Paramount Software Solutions, Inc

    - Atlanta, GA

    Title: Oracle Database Administrator ​Location: Atlanta, GA Duration: 6+ Months contract Job Purpose: Install, upgrade and configure university database systems and ...

    5 hours ago from Dice
  • Data Scientist

    Principle Solutions Group

    - Atlanta, GA

    Data Scientist (Marketing Analytics) A fortune 50 company based in the Atlanta metro area is searching for a smart Data Scientist to solve critical marketing problems. The ...

    30+ days ago from Principle Solutions Group
  • Oracle Apps DBA/Installation Engineers

    eSolutions Group

    - Atlanta, GA

    Greater Atlanta area, GA Number of Positions - 2 Full time position, direct hire Oracle DBA/Installation engineers to manage their internal development environments and ...

    24 days ago from ERP-Consulting
  • Oracle DBA

    NEW

    Syrainfotek

    - Atlanta, GA

    Job Title: Oracle DBA Location: Atlanta, GA Duration: 12 Months Rate: Open Description du poste -Designs, develops, modifies, & evaluates database related utilities & tools ...

    3 hours ago from Tech Fetch

Show Me More