Job Responsibilities
· Administer DB2 LUW databases on Linux platform.
· Install, upgrade and patch DB2 databases.
· Strong with backup and recovery.
· Conduct performance tuning of high scale databases
· Strong experience in setting up DR databases and perform DR tests
· Experience with automation using shell scripting or Ansible
· Experience working with development teams for object deployment and setting up data replication using federation and other data replication tools like Attunity, DTShare etc.
· Provides status report updates to manage More...
Job Description:
Requirements:
· 8+ years of experience as an AS/400 DB2 DBA.
· Proficiency in database normalization and design.
· Strong expertise in SQL query tuning and process optimization.
· In-depth understanding of RPG/400 performance tuning.
· Excellent problem-solving and troubleshooting skills.
Responsibilities:
· Manage and administer DB2 databases on AS/400 systems.
· Normalize databases to improve efficiency and design.
· Optimize SQL queries and database processes for better performance.
· Analyze and implement performance improvements More...
About the Role
DB2 Database Administrator with strong DBA experience to handle databases on Linux platform.
Job Responsibilities
· Administer DB2 LUW databases on Linux platform.
· Install, upgrade and patch DB2 databases.
· Strong with backup and recovery.
· Conduct performance tuning of high scale databases
· Strong experience in setting up DR databases and perform DR tests
· Experience with automation using shell scripting or Ansible
· Experience working with development teams for object deployment and setting up data replicati More...
Exploring The Information Technology Job Industry In Lake Forest
Lake Forest is located in Lake County, Illinois. Lake Forest lies along the shore of Lake Michigan. Lake Forest has a diverse population that includes White, Asian, Hispanic, African American, Native American, and Pacific Islander communities. Prestone, IDEX, Trustmark, and Covered Logistics have their headquarters in Lake Forest. The best time for visiting Lake Forest is during June, August, and September. CDW, The Home Depot, Life Time, Aon, and Apple are some IT organizations in Lake Forest.A Quick Understanding Of The DBA Skill Job Prerequisites
Database administrator jobs require professionals with a Bachelor's degree in Computer Science, with relevant experience in handling database products. Database administrators must have the efficiency to monitor technical support for database applications and database systems for maintaining a secured database.Investigating The Job Responsibilities Of A DBA Candidate
The main responsibility of a database administrator is to create reports in the pre-formatted form or customized ad-hoc reports generated by the database administrator. Database administrators upgrade database servers and application tools, allocate system storage, and plan storage requirements for database systems.Evaluating The Salary Scale Of A DBA Candidate In Lake Forest
The average annual salary for certified database administrators ranges from $94,000 to $104, 000.