What are the responsibilities and job description for the Database Administrator II position at BlueSky Resource Solutions?
Job Responsibilities:
- Troubleshoot, analyze for root causes for problems, ensure database availability, security and stability, performance tuning and optimization.
- Able to provide performance tuning by analyzing Database and O/S performance using Explain, Event Monitors, vmstats, etc.
- Able to Install DB2 sotfware and upgrade DB2 instances and databases. Install DB2 client versions and the drivers on the application servers and users' machines.
- Able to write and maintain BASH/KSH shell scripts.
- Good application management experience including but not limited to Explains, Joins, Referential Integrity, Stored Procedures and Triggers, indexes.
- Provides guidance to Developer's technical questions related to Db2 as well as creating and updating Stored Procedures and Triggers.
- Analyze and tune SQL statements and indexes; make performance recommendations to development teams.
- Experience in problem analysis and troubleshooting database related issues.
- Manages and maintains data in all Production and Non-Production Db2 Databases.
- Handles data refreshes from Production to Test environments based on user requirements.
- Performs maintenance of the Db2 environments including image copies, performance monitoring, capacity management, and object upgrades.
- Experience with all Db2 utilities including Backups, Unloads, Loads, Runstats and Reorgs.
- Can perform database recovery to Image Copy or Point-In-Time.
- Install and manage the TSA Cluster and HADR
- Good oral and written communication skills with the ability to communicate technical concepts.
- Results oriented with strong attention to detail.
- Self-motivated and team player.
Required Qualifications:
- 5 years experience with recent versions of Db2 LUW(Linux, Unix, Windows) and Red Hat.
- Provides 24x7 on call support and work as needed after normal working hours to implement changes.
- Additional experience with MySQL and/or SQL Server database administration is desired.
BlueSky Resource Solutions is an equal opportunity employer. We are committed to creating an inclusive environment for all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
