CareMedic Systems

DBA / ETL Specialist

Department: Information Technology
Reports To: Vice President Technology / DBA Manager
Status: Permanent, Full Time
Category: Salary, Exempt
Location: Decatur, GA
Revision Date: July 1, 2009


Position Summary:

The DBA / ETL Specialist conducts database administration, installation, and maintenance of operational, test and development database systems. They will be responsible for ETL operations and the management of these processes.
Business casual environment, medical dental life insurance, 401 K, tuition reimbursements are just a few of the many benefits.

Essential Duties and Responsibilities: 

• Routine database maintenance, installation, and configuration 
• Establish, Monitor and Maintain ETL processes to move data through the system 
• Database performance monitoring 
• Security policy configuration and administration 
• Replication administration 
• Analyze system and user requirements 
• Space management and planning 
• Upgrades and new implementations 
• Ensure the operation and security of all Database environments 
• Act as contact for Mission Critical transaction processing database servers 
• Perform troubleshooting for system and database related problems 
• Ensure corporate release and security policies are adhered to 
• Perform testing and troubleshooting 
• Audit and maintain security levels consistent with the Security Policies. 
• Performing intrusion testing, identifying & correcting security vulnerabilities and implementing security related software 
• Enhance existing and recommend new technologies to improve company efficiency and quality 
• Provide technical assistance to all staff 
• Other duties as assigned

 
Supervisory Responsibilities:
N/A

Qualifications:

The person successfully performing this role will exhibit the following competencies and /or meet the following minimum requirements: 

• Principles of relational database systems and architectures 
• Solid understanding of the SQL language and current trends in technology and architecture 
• Minimum of 4 years as a SQL Server DBA 
• 2 to 4 years of Pervasive/SSIS or other Data Manipulation software 
• Knowledge of operating systems, Servers, and networking components 

Ability to: 

• Independently research, analyze, and determine cause and conditions. 
• Take the appropriate action for complex technical solutions and problems 
• Troubleshoot database performance issues 
• Write technical specifications 
• Prioritize workload effectively 
• Perform well under pressure 
• Meet critical deadlines 
• Communicate effectively with users, management and outside vendors 
• Work independently and as a team member 
• creates and maintains a disaster recovery plan 
• Resolve problems associated with new and legacy software and hardware running on various platforms 

• Test / Implements / Recommends upgrades, patches, and service packs 
• Implements new database applications, databases and hardware 
• Provides technical support and guidance to users 
• Working experience with storage technologies including SAN, NAS 
• Excellent verbal, written, listening and interpersonal skills 
• Demonstrated Dependability 
• Bachelor Degree and / or equivalent prior experience in a technical discipline 
• Responsible for the day-to-day maintenance and support of our Database systems 
• Provides troubleshooting skill for customer's problems and resolves issues including tuning queries 
• In depth understanding of database programming such as triggers and stored procedures 
• Reviews and deploys Database related code in Development, QA and Production 
• Provides technical Database administration oversight 
• Ability to work on multiple projects simultaneously 
• At least 4-5 years hands on experience working with MS SQL 2000/2005. 
• COGNOS experience a plus. 
• MCDBA certification, COGNOS certification a plus

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands and arms, including the need to reach with arms. The employee is frequently required to sit; stand; walk; reach with hands and arms; balance; stoop; kneel and/or crouch. The employee must occasionally lift and/or move up to 20 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly exposed to computers, printers and copiers. The noise level in the work environment is usually moderate.

Travel

Estimated travel - 5%
This position will be required to support multiple locations.