Database Administrator

Company: Apex Systems ( Learn More )

General Information
US-RI-Pawtucket
N/A
4 Year Degree
Full-Time
Not Specified
Not Specified
False
False
Job Description

Apex Systems combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country.

Apex has an opportunity for a Database Administrator role in the Providence, RI area. This is a Permanent position and the pay rate is flexible depending on experience. Here are the details:    

Role: Database Administrator

Duration: Permanent

Location: Providence, RI

Rate: Flexible based on experience

Must Haves:

  • Datawarehousing
  • Data Mapping
  • Strong SQL (NO Oracle)
  • Working independently, good communication and experience working with the business side.
  • EDUCATION/EXPERIENCE:

  • B.S or B.A. degree is preferred
  • Minimum of 5 years of experience working with Microsoft SQL Server
  • 2-3 years in Application Administration
  • PURPOSE OF THE ROLE:

    The Database Administrator is responsible for supporting applications and databases deployed. The Database Administrator is responsible for maintaining production support for applications as well as ensuring the databases are functioning properly, taking backups of the repositories, performing maintenance on the systems (building and maintaining indices to ensure applications perform effectively and data can quickly be accessed), and managing the growth, patching, and end-of-life of the applications and databases to ensure the applications are running on efficient, manageable, and supported platforms. Most applications are reliant on a properly configured and running database in order to function properly. This resource will work closely with other members of the Database administration team, members of the technical infrastructure team (server, storage, network, security teams, etc.), application development teams, enterprise architecture, vendors, as well as with IT business liaisons to ensure smooth operations of applications and databases within the environment.

    DUTIES/RESPONSIBILTIES:

    Day to day SQL Server administration and support.

    • Support and administer various versions of SQL Server (SQL 2005 to SQL 2016)

    • Support of MySQL, Sybase, and other smaller installed databases

    • Installing new databases and upgrade existing installation to support business requirements

    • Research and resolve database software and operating issues

    • Monitor systems and proactively respond to issues

    • Ensure that configuration of databases includes appropriate security setup for internal and/or external databases

    • Work with business partners to schedule maintenance and communicate incidents

    • Independently troubleshoot problem tickets and work with vendors to rectify issues

    • Database software patching and day-to-day management

    • Perform off hours on call support on a rotating basis

    • Support the capturing and reporting of data access metrics

    • Monitor database utilization and database space consumption trends

    • Manage increasing capacity of database data files

    • Develop and support data cleanup, monitoring, archiving procedures

    • Support and refresh test environments to support business support needs

    • Manage SQL installations configured on Microsoft Clustering platform

    • Support and refresh dev/test environments to support business support needs

    • Support the backup and recovery of corporate data

    • Configure new backups of databases using native SQL backups, lightspeed and DD boost

    • Assist with data backup and recovery

    • Research and implement new trends and advances in database solutions and practices

    • Help create strategic roadmaps for Hasbro database technologies

    • Provide assistance for disaster recovery planning and testing

    • Support the build/recovery of systems during the annual Disaster Recovery (DR) test

    • Assist with documenting and maintaining the standard operating procedures for DR

    Day to day application administration and support.

    • Performing application installs, upgrades and patching

    • Performing Break/fix for application related issues

    • Monitor, manage, and trend application performance

    • Perform day-to-day administration of custom and off-the-shelf applications deployed in the Hasbro environment

    • Working with the enterprise architecture team to come up with the application roadmap

    • Work collaboratively with app dev teams as well as infrastructure teams

    SPECIALIZED KNOWLEDGE AND SKILLS:

    • Microsoft SQL Server Database Administration expertise (3 years minimum)

    • Experience with the recent versions of Microsoft SQL Server (2005, 2008 and 2008R2, 2012, 2014, 2016)

    • Experience managing and supporting large MS SQL Data warehouse

    • Experience with data backup, recovery and SQL Server maintenance using SQL back up, lightspeed and DD boost

    • Experience with SQL Server performance tuning and troubleshooting

    • Experience supporting a secondary database platform besides SQL Server (MySQL, oracle, DB2, Sybase, etc.)

    • Experience working with Microsoft Clustering for High Availability

    • Experience with database replication technologies

    • Must possess a very high technical aptitude

    • Must be an outstanding team player

    • Must possess superior analytical and trouble-shooting skills

    • Must have a sense of urgency in meeting project and task deadlines and in resolving production issues

    • Strong verbal and written communication skills are mandatory

    • Superior organizational skills and work methods are necessary for this position

    • Must demonstrate initiative and be a self-starter

    • Must be innovative in developing server solutions

    • Must have a thorough understanding of change management concepts

    • Systems administration experience in a large heterogeneous Windows/UNIX/Linux production environment is required

    • Supporting mission critical externally facing systems

    • Working with enterprise class virtualization technologies.

    • Business analysis and enterprise application support in a multinational and matrixed organization.

    • ITIL V.3 certification preferred

    For applicants who are interested in this Database Administrator opportunity; please send a Word resume to Cassie Wagner, Professional Recruiter @ [Click Here to Email Your Resumé].


    Job Requirements