What are the responsibilities and job description for the Database Administrator position at Staffingine LLC?
Job Details
Location - Dallas, TX / Chicago, IL
Job Description
- Responsibility for constructing and/or optimizing physical database designs tailored for the DB2 UDB/LUW database environment in support of various strategic application development initiatives (database/table/object/index/view/trigger/package/procedure etc).
- Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
- Design & development Services - Physical database design and creation, partitioning, capacity planning, DDL creation update etc., view design and creation, stored procedure, trigger and query coding and tuning
- Data Services - Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking
- Performance and Tuning Services - Performance Profile baseline, database tuning, index reviews, query tuning.
- Data backup & management services Backup requirements, backup plan, recovery plan, disaster recovery backup plan, data archiving & purge, utilities and SSIS support, reorganization strategy and maintenance plan
- Database and OS Upgrade Services - Transition to different DBMS or operating system, support upgrade-related issues per application
- Security Services - Non-standard Security role setup
- HOTS turnover plan
- Database connectivity support activities
- Undertaking the planning and carrying out of system upgrade initiatives and database recovery actions as required and generally contributing toward the overall online availability goals of the organization.
- Perform feasibility studies and cost estimates in response to user requests.
- Query performance monitoring, tuning and recommendation.
- Position requires the individual to carry a cell phone and be available at all times
Must have:
DB2 UDB/LUW Database Expertise Strong knowledge of DB2 Universal Database (UDB) for Linux, UNIX, and Windows (LUW).
Physical Database Design & Optimization Experience in database/table/object/index/view/trigger/package/procedure creation and optimization.
Performance Tuning & Query Optimization Ability to monitor and optimize query performance, index strategies, and database tuning.
Stored Procedures & Triggers Proficiency in writing and tuning stored procedures, triggers, and complex queries.
Data Replication & Change Data Capture (CDC/IIDR) Experience with data replication strategies and change tracking solutions.
Database Backup, Recovery, and Disaster Recovery (DR) Strong understanding of backup strategies, disaster recovery planning, and data archiving.
Database and OS Upgrades Experience transitioning between different database versions, DBMS, or OS upgrades.
Security & Access Control Expertise in setting up and managing security roles, authentication, and authorization.
System & Application Support Experience supporting application development teams with database designs and changes.
DB2 Utilities & SSIS Support Familiarity with DB2 utilities, reorganization strategies, and integration services (SSIS).
