Performs all aspects of data and database administration including hardware and software evaluation and installation, logical and physical database design and implementation, structured testing of database designs, applications, and technology platforms, security administration, backup and recovery planning, capacity planning, performance and tuning, research and evaluation of new tools and techniques, and development of policies, standards and procedures related to the database environment.

Essential Functions

• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Test programs or databases, correct errors and make necessary modifications.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
• Specify users and user access levels for each segment of database.
• Modify existing databases and database management systems or tech support to make changes.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Review procedures in database management system manuals for making changes to database.
• Review project requests describing database user needs to estimate time and cost required to accomplish project.
• Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
• Revise company definition of data as defined in data dictionary.
• Select and enter codes to monitor database performance and to create production database.
• Monitor SQL Server performance, administration jobs, SQL auditing, error logs, tuning T-SQL queries, stored procedures.

Non-Essential Functions

• Performs routine and customary operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs
• Plans and executes testing and implementation of major systems
• Evaluates technology and techniques to implement and maintain databases and database environment
• Develops, implements and tests backup and recovery plans

Knowledge & Skills

• 5 years experience with database technology
• Expert in designing and creating tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects.
• Experience in extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert, BCP and DTS/SSIS Packages.
• Superior knowledge and experience with custom report generation using SSRS 2008 (SQL Server Reporting Services)
• Experience with Installation/Configuration and administration of SQL servers (2005 and 2008) in both Clustered/Non-Clustered environment.
• Extensive experience in Query Optimization and Troubleshooting of SQL Server related issues.
• Proficiency with dynamic SQL
• Experience with Apex SQL Toolsets or other similar tools a plus
• The ability to communicate information and ideas in speaking so others will understand.