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

  • DB2 DBA

    Principle Solutions Group

    - Atlanta, GA

    We have a great opportunity for a DB2 z/OS Database Administrator with experience supporting 24/7 availability of mission critical databases. This position allows you the ...

    9 days ago from Principle Solutions Group
  • Data Scientist

    NEW

    Verizon Wireless HQ IT and NET

    - Alpharetta, GA

    Grow your IT career at one of the leading global technology companies. We offer hands-on exposure to state-of-the-art systems, applications and infrastructures. ...

    1 day ago from Verizon Wireless
  • Senior Oracle DBA

    NEW

    Rose International

    - Atlanta, GA

    Senior Oracle DBA Location Atlanta , Georgia 30303 Duration 08032015 - 12312015 Description bull Minimum 10 yearsrsquo experience bull Oracle certifications ndash 9i, ...

    19 hours ago from Dice
  • Oracle DBA

    NEW

    Synergis

    - Atlanta, GA

    Our client is an award winning leader within their industry, specializing in energy management. They have been recognized by Computerworld's Top 100 Best Places to Work ...

    19 hours ago from Jobg8
  • REGISTRAR ONCOLOGY DATA CENTER GMC (7766)

    Gwinnett Medical Center

    - Lawrenceville, GA

    Requisition #:7766 Job Title:REGISTRAR ONCOLOGY DATA CENTER GMC Department: ONCOLOGY DATA CENTER GMC Hourly Rate: Min: $16.39- Mid: $21.31 Work ...

    28 days ago from Gwinnett Medical Center
  • 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 ...

    16 days ago from Principle Solutions Group
  • Oracle DBA

    NEW

    TechnoGen

    - Atlanta, GA

    Required They need some with strong experience in Performance Tuning Expert level of experience in performance tuning in RAC environment How to tune workload in RAC ...

    1 day ago from Tech Fetch
  • Oracle Database Administrator

    NEW

    ESG Consulting

    - Alpharetta, GA

    Seeking a skilled Oracle Database Administrator to manage high-performance databases that support our Applications. This role will be responsible for the definition, tuning, ...

    18 hours ago from Dice
  • Need Data Recovery Expert

    NEW

    Private Contract

    - Smyrna, GA

    Media type(s): USB drive. Data type: Personal, Business. Device make and model: USB drive. Issues: Other (the port broke to my USB drive that goes into the computer). Is ...

    2 days ago from Thumbtack
  • Middleware Administrator

    Verizon

    - Alpharetta, GA

    Grow your IT career at one of the leading global technology companies. We offer hands-on exposure to state-of-the-art systems, applications and infrastructures. ...

    29 days ago from Verizon

Show Me More