The Database Administrator (DBA) will provide technical support and administration to all organizational SQL Server and Access databases. The DBA will work closely with developers, IT staff, and users to provide technical support, maintenance, and logistical support to production and test systems.
PRINCIPAL RESPONSIBILITIES INCLUDE:
•Create, configure, size and maintain enterprise databases with high availability.
•Perform overall health checks and maintenance tasks such as indexing, performance tuning, backup/recovery, and partitioning on the databases at regular intervals.
•Develop database monitoring, operational processes and procures/standards that will continually improve the operation of the whole environment.
•Develop and track database server performance metrics.
•Create and manage ETL packages, triggers, stored procedures, views, and SQL transactions.
•Develop new and provide support for secure data feeds with external parties as well as internal applications including the data warehouse and business intelligence applications.
•Perform analysis and QA .
•Diagnosis ETL and database related issues, perform root cause analysis, and recommend corrective actions to management.
•Work with application developers to support the design, development, implementation, monitoring, and maintenance of new programs and systems.
•Coordinate training sessions with application developers to cross train on essential database and SQL tuning skills.
•Effectively communicate technical issues and proposed solutions to key management staff.
•Establish and maintain a close working relationship with all user departments and groups.
•Be available to provide production support 24/7 as needed.
ESSENTIAL FUNCTIONS OF THE JOB:
•Technical job knowledge: Core competency required in supporting Microsoft SQL Server environments as well as ETL programming.
•Communications: Preparing written and oral reports and documenting related key information services.
•Customer service: Building and maintaining working relationships with key personnel in other departments.
•Constant and close visual work at desk or computer.
•Constant sitting and working at desk.
•Constant data entry using keyboard and/or mouse.
•Frequent verbal and written communication with staff and other business associates by telephone, correspondence, or in person.
•Frequent lifting of folders and other various objects weighing between 0 and 30 lbs.
•Frequent walking and standing.
•Occasional driving of automobiles.
sologig - 13 months ago