DB2 Database Administrator

4 weeks ago


Providence, United States AtWork Personnel Services Full time
Job DescriptionJob Description

We are looking for a mid-level DB2 DBA to join a gaming machine manufacturing company located in Rhode Island. The candidate will be responsible for managing all levels of the physical database design, maintenance and support functions on database platforms for all types.

This is a hybrid position (2 days office, 3 days remote) where candidate must live in Rhode Island.

Responsibilities

  • Responsible for managing all levels of the physical database design, maintenance and support functions on database platforms for all types.
  • Provides technical assistance in identifying, evaluating systems and procedures as they relate to databases.
  • Have a solid understanding of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
  • Design the migration paths from older versions of DB2 to the latest releases
  • Develops maintenance strategy and maintenance scripts.
  • Ensures accuracy and availability of data.
  • Establishes policies and procedures pertaining to database management, security, maintenance and utilization.
  • Analyzes database performance statistics and performs required tuning activities to optimize database performance.
  • Understands database backup/recovery procedures and develops backup scripts.
  • Recommends continuous improvement in database administration.
  • Shared on-call responsibilities in 24 x 7 operation.

 

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or a related field with an emphasis on database theory.
  • 2 - 4 years of database management experience
  • In-depth knowledge of SOL and database performance optimization.
  • Experience with DB2 first and foremost, Oracle, MySQL and SOL Server 2000.
  • Experience with DB2 version 8.1, 9, 10, 11.
  • Experience with Oracle to DB2 migrations
  • Experience with C-tree database is a plus
  • Experience in optimizing SOL queries generated by ORM frameworks like hibernate
  • Experience working with local and remote DB recoveries
  • Experience working with Enterprise level systems requiring high levels of performance and availability
  • Self-starter and ability to work with Customers and understand their requirements
  • Strong communicator with a proven ability to build and maintain collaborative relationships

 

Company DescriptionFor over 30 years, clients and candidates have entrusted AtWork to provide workforce solutions nationwide. With over 75 offices nationwide, AtWork specialize in executive, professional, commercial, and government verticals. AtWork utilizes a collaborative approach where we deliver quick, high-quality results. Our customizable service portfolio focuses on direct-hire and flexible workforce solutions. Since 1986, AtWork has continued to be an award-recognized leader in the staffing industry by clients, candidates, and industry professionals.Company DescriptionFor over 30 years, clients and candidates have entrusted AtWork to provide workforce solutions nationwide. With over 75 offices nationwide, AtWork specialize in executive, professional, commercial, and government verticals. AtWork utilizes a collaborative approach where we deliver quick, high-quality results. Our customizable service portfolio focuses on direct-hire and flexible workforce solutions. Since 1986, AtWork has continued to be an award-recognized leader in the staffing industry by clients, candidates, and industry professionals.

  • Providence, Rhode Island, United States Brown University Full time

    Job Summary:This position provides administrative support to the School of Public Health, specifically in the areas of website and database maintenance, and event-planning coordination for one or more of the four academic departments.Key Responsibilities:Assist in maintaining the school's website and database, ensuring accuracy and up-to-date...

  • PowerApps Developer

    3 weeks ago


    Providence, United States Stellar IT Solutions LLC Full time

    Job Title: PowerApps Developer Job Location: 100% Remote Interview: Virtual Job Duration: 6 Months Project Overview: The teams automations and lowcode/nocode solutions have primarily been built within G Suite but there is limited expertise on the Googlespecific components. The project involves working with large applications which require more than just...

  • Office Administrator

    2 weeks ago


    Providence, United States MSCCN Full time

    The primary objective of the Office Administrator to oversee the daily operations of our office. The ideal candidate will have excellent organizational skills, strong leadership abilities, and a keen eye for detail. This role involves managing administrative functions, supporting staff, and ensuring a smooth and efficient office environment. Independently...


  • Providence, United States Brown University Health Full time

    Summary: Under the direct supervision of the Principal Investigator and Leadership the Administrative Coordinator will provide high-level administrative support to assigned research and programmatic activities associated with various clinical and public health projects. Projects will include those related to HIV prevention HIV education pre-exposure...


  • Providence, Rhode Island, United States Providence College Full time

    Job Summary">We are seeking a highly organized and detail-oriented Senior Office Assistant to join our Advancement Services team at Providence College. This is a full-time position that offers a competitive salary of $36,000 - $38,000 per year, along with a comprehensive benefits package.">About the Role">In this role, you will provide administrative support...


  • Providence, United States Semper Home Loans Full time $65,000 - $90,000

    About Us:Semper Home Loans is a leading mortgage lender, licensed in 42 states, headquartered in Providence, RI. We are dedicated to providing homebuyers with superior mortgage products and services. As part of our commitment to operational excellence, we are seeking an experienced Encompass Administrator to manage and enhance our Encompass Loan Origination...


  • Providence, United States The Contingent Plan Full time

    Job Description The Contingent Plan is actively recruiting an experienced administrative coordinator for a healthcare delivery client in the Providence area. This is a temporary assignment that is expected to last 3 months. The position is onsite, so the client is only considering local candidates at this time. This is an immediate need, so the client will...


  • Providence, United States LifeSpan Full time

    SUMMARY: Under general supervision perform a variety of secretarial and administrative functions. May include functional supervision of clerical support staff. REQUIRED QUALIFICATIONS: Associates Degreeor equivalent experience. Knowledge of PC word processing and spreadsheet software applications required. Three to five years progressively more...


  • North Providence, United States Eliassen Group Full time

    Seeking Mainframe Senior Test Automation Engineer Join one of the largest mutual fund companies in the US, recognized as one of Forbes' World's Best Employers (2024) and America's Best Employers for Tech Workers (2024) in Smithfield, Rhode Island . Committed to innovation and excellence in the financial services industry. Key Technical Skills: Proven...


  • East Providence, United States Brown University Health Full time

    Summary: The Pediatric Anxiety Research Center at Bradley Hospital is an integrated research and clinical center nationally recognized in pediatric OCD and anxiety. PARC is affiliated with the Warren Alpert Medical School of Brown University and encompasses research projects outpatient services and an Intensive Treatment Program for OCD and related...


  • East Providence, United States Lifespan Full time

    Summary: The Pediatric Anxiety Research Center at Bradley Hospital is an integrated research and clinical center nationally recognized in pediatric OCD and anxiety. PARC is affiliated with the Warren Alpert Medical School of Brown University and encompasses research projects outpatient services and an Intensive Treatment Program for OCD and related...

  • Sr Oracle Clou DBA

    2 weeks ago


    Providence, United States PamTen Full time

    Responsibilities Database Administration: Administer and maintain Oracle ATP databases, including installation, configuration, user management, schema management, storage management, backup and recovery, and performance tuning. Backup and Recovery: Implement and maintain backup and recovery strategies to safeguard data against loss or corruption and...


  • Providence, Rhode Island, United States Rhode Island College Full time

    Rhode Island College seeks a detail-oriented Data Coordination Specialist to join our team at the Paul V. Sherlock Center on Disabilities.The successful candidate will be responsible for utilizing databases, spreadsheets, and other data tools to support data collection and reporting related to grants and contracts. This includes maintaining specific...


  • Providence, Rhode Island, United States Brown University Health Full time

    Job Summary:As a key member of the Brown University Health Development team, the Donor Research Specialist plays a critical role in identifying and managing donor prospects. This position requires a high level of organizational skills, exceptional communication abilities, and a strong understanding of database management applications. The ideal candidate...


  • Providence, Rhode Island, United States Delphi-US Full time

    Database Administrator Position OverviewDelphi-US is seeking a skilled Database Administrator to join their team in Providence, RI/Hybrid. The successful candidate will be responsible for monitoring and reporting financial, key performance indicator, and other data for American Rescue Plan Act (ARPA) projects.Key Responsibilities:• Monitor and report...


  • Providence, Rhode Island, United States Manufacturing Inc Full time

    We are seeking a motivated and enthusiastic Customer Service Admin to join our dynamic team at Manufacturing Inc. In this role, you will provide exceptional administrative support while delivering top-notch customer service. No prior experience is required; we are happy to provide full training. If you are eager to learn and grow within a collaborative...


  • Providence, United States InsideHigherEd Full time

    Web Developer/Senior Web DeveloperBrown UniversityTo view the full job posting and apply for this position, go to: $RedirectResponseJob Description:Web Developer/Senior Web Developer Office of Information TechnologyThe Web Developer/ Senior Web Developer is responsible for assisting with planning, designing, coding, documenting, testing and maintaining...


  • Providence, United States Manufacturing Inc Full time

    We are seeking a motivated and enthusiastic Customer Service Admin to join our dynamic team! In this role you will provide exceptional administrative support while delivering topnotch customer service. No prior experience is required; we are happy to provide full training. If you are eager to learn and grow within a collaborative environment this is the...


  • Providence, United States Manufacturing Company Full time

    About the job Customer Service Specialist We are seeking a motivated and enthusiastic Customer Service Admin to join our dynamic team! In this role, you will provide exceptional administrative support while delivering top-notch customer service. No prior experience is required; we are happy to provide full training. If you are eager to learn and grow within...


  • Providence, Rhode Island, United States Trillium Staffing Full time

    Job Summary:Trillium Professional is seeking a highly skilled Data and Applications Assistant to join their team. This is a 3-year contract position with the Department of Administration's Rebate Program. The successful candidate will work in a hybrid role, splitting their time between onsite and remote work.Key Responsibilities:• Process rebate...