What are the responsibilities and job description for the Database Administrators (DB2) position at Randstad Digital Manual LLC?
Database Administrators (DB2) for Randstad Digital, LLC. Multiple openings. Headquarters: Woburn, MA. Administer, test, design and implement DB2 database environments. Set up log retention policies and archive strategies to cover outages, translate business requirements, design data models. Review performance, availability, recoverability, data access methods, remediation, verification processes, features, functions, exception reports, audits, SOX reviews, deliverables, milestones, scalability, data integrity, regulatory compliance, schema designs, indexing, tablespace allocation, partitioning, storage, peak transaction volumes, batch processing windows, concurrency, throughput, patches, vulnerability, impact, queries, paths, buffer pools, database health, bottlenecks, migrations. Confer with application teams, define backup and disaster recovery strategies for production environment, support product upgrades, test and validate recovery procedures, provision privileges and roles, support replication technologies. Maintain operational documentation, runbooks, configuration standards, change records. Support high volume OLTP and batch production systems in mainframe environment. Identify issues, satisfy client/user needs, recommend database modifications. Use DB2, BMC, Change Manager, Catalog Manager, Mainview, z/OS, ETL, SQL, DB2 EXPLAIN, RUNSTATES, REBIND, Omegamon, DB2 Detector, Informatica, Data Stage, SSIS, AWS, Azure, ServiceNow, Buffer Pool Tuning, CDC, IDAA, RACF, JCL, TSO, ISPF, QMF, Log Analyzer, Erwin Data Modeler. 40 hrs/wk. Must have Master's degree or foreign equivalent in Computer Science, Computer Engineering, Information Technology, Electronic Engineering, or a related field and 2 years experience in the proffered position, or as a Developer, Software Engineer, Technology Analyst, Programmer Analyst, or related occupation. In the alternative, will accept a Bachelor s degree or foreign equivalent in the specified fields plus 5 years of progressive, post-baccalaureate experience in the specified occupations. Must have 2 years of experience administering databases; designing data models; reviewing performance, availability, recoverability, data integrity, indexing, tablespace, storage, queries, migrations, backup; using DB2, Mainview, z/OS, ETL, SQL, DB2 EXPLAIN, Omegamon, DB2 Detector, Informatica, Data Stage, SSIS, AWS, Azure, CDC, IDAA, JCL, TSO, ISPF, Log Analyzer. Must be willing to travel/relocate to unanticipated locations throughout the US on short notice for extended periods of time. Telecommuting permitted. $153,879 to $153,900/yr. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). To apply, email resume to rd-apply.rits@randstaddigital.com. Reference job Database Administrators (DB2) and Ref ID#849371 in the subject line. This position is eligible for incentives pursuant to Randstad Digital, LLC Employee Referral Program.
Salary : $153,879 - $153,900