This site uses cookies. To find out more, see our Cookies Policy

Senior Database Administrator in Lansing, MI at AF Group

Date Posted: 5/22/2018

Job Snapshot

Job Description

Responsible for the day-to-day maintenance and monitoring of Oracle and SQL server databases. Interact with development staff in all areas of database design and operation.





RESPONSIBILITIES/TASKS:




  • Refresh non-production databases.
  • Perform routine, day-to-day database administrator duties and observe more senior database administrators in order to build skills in data modeling, SQL and PL/SQL tuning, application tuning, creation of database objects, data modeling, utilities, UNIX commands and UNIX programs.
  • Participate on committee that sets SQL and PL/SQL programming standards.
  • Consults with users to identify current database requirements and clarify objectives.
  • Review documented processes and procedures.
  • Develop understanding of and stay current with advances in information technology by reading manuals, trade periodicals, and technical reports relating to Oracle and SQL Server databases.
  • Provide technical assistance to other Information Services personnel.
  • Maintain confidentiality of information processed.
  • Participate in on-call rotation for production database support.



    ADDITIONAL RESPONSIBILITIES/TASKS FOR SENIOR DATABASE ADMINISTRATOR:


  • Make technical recommendations and implement policies and standards relating to the architectural design of databases, network communications, data access and security requirements, and backup and recovery procedures for production and development databases.
  • Create and refresh non-production databases.
  • Monitor and manage database growth and size requirements.
  • Plan, develop, test, and tune databases.
  • Assist and mentor development staff in data modeling, SQL and PL/SQL tuning, application tuning, creation of database objects, utilities, UNIX commands and UNIX programs.
  • Install third-party applications for testing and implementation in production.
  • Lead committee the set SQL and PL/SQL programming standards.
  • Develop and maintain SQL and UNIX programs to monitor database conditions and activities.
  • Identify application and/or SQL performance problems and assist in their resolution.
  • Analyze, review, and alter database parameters and structure to increase operating efficiency or adapt to new requirements.
  • Consults with users to identify current database requirements and clarify objectives.
  • Document current, revised, and new processes and procedures.
  • Perform prototyping and database tuning and optimizing.
  • Stay up to date with advances in information technology by reading manuals, trade periodicals, and technical reports relating to Oracle and SQL Server databases.
  • Provide technical assistance to other Information Services personnel.
  • Work with minimum supervision and exercise sufficient discretion and independent judgment.
  • Mentors peers and IT personnel.
  • Manage relationship with Oracle and Windows Support.
  • Analyze and plan for future database, server, storage, and network requirements.
  • Gather database statistics for trend analysis.
  • Research and plan implementation of new database features and enhancements.
  • Design database growth management strategies.
  • Design database backup and recovery strategy including usage of standby databases for Business Resumption Plan.
  • Produce periodic reports for management and staff.
  • Work with no supervision and exercise discretion and independent judgment.

    This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.





    EDUCATION:



    Bachelor's degree in computer science, information technology, or related field required. Certification or progress toward certification of, industry-recognized professional designation in Oracle and SQL preferred and encouraged. Combinations of relevant education and experience may be considered in lieu of a degree. Continuous learning, as defined by the Company's learning philosophy, is required. Oracle Certified Associate, Oracle Certified Professional and/or Microsoft Certified Solutions Assistant: Sql Server preferred.





    EXPERIENCE:



    Database Administrator

    Three to five years experience within an IT environment which provides the necessary skills, knowledge and abilities. One year relevant experience with Oracle and/or SQL Server databases preferred. Experience within the insurance industry highly preferred.



    Senior Database Administrator

    Five years experience within an IT environment which provides the necessary skills, knowledge and abilities. Three years relevant experience with Oracle and/or SQL Server databases or maintaining a production environment preferred. Experience within the insurance industry highly preferred.





    SKILLS/KNOWLEDGE/ABILITIES (SKA) REQUIRED:




  • Ability to troubleshoot client/server problems.
  • Ability and proficiency in the use of computers and company standard software specific to position.
  • General understanding of database administration.
  • Basic knowledge of Oracle and/or SQL Server database management tools.
  • Basic knowledge of SQL and PL/SQL, UNIX commands.
  • Excellent oral and written communication skills.
  • Ability to apply the principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions.
  • Ability to comprehend the consequences of various problem situations and to make sound decisions or to refer problems to appropriate people for decision making.
  • Ability to manage multiple projects and meet necessary deadlines.
  • Ability to work varying hours, including evenings, weekends and holidays as required.
  • Ability to perform other assignments at locations outside the office.



    ADDITIONAL SKAs REQUIRED FOR SENIOR DATABASE ADMINISTRATOR:


  • Ability to work closely with Database engineers to implement standards, policies and procedures developed.
  • Ability to document and develop standard operating procedures for day to day activities.
  • Ability to make technical recommendations. Demonstrated high level of competency in Oracle and/or SQL Server database administration.
  • Thorough knowledge of and ability to use Oracle and/or SQL Server database utilities and management tools.
  • Thorough knowledge of SQL and PL/SQL, UNIX commands, and shell programming.
  • Ability to establish work flows, manage multiple projects, and meet necessary deadlines.
  • Advanced knowledge of communication layer between client, network and Oracle/SQL Server databases.
  • Advanced knowledge of and demonstrated competency in all facets of Oracle and/or SQL Server database administration.



    WORKING CONDITIONS:



    Work is performed mainly in an office environment with minimal hazards. May be exposed to temperatures, which may be cooler than a normal office setting. Travel may be required.

    The qualifications listed above are intended to represent the minimum education, experience, skills, knowledge and ability levels associated with performing the duties and responsibilities contained in this job description.

    We are an Equal Opportunity Employer. Diversity is valued and we will not tolerate discrimination or harassment in any form. Candidates for the position stated above are hired on an "at will" basis. Nothing herein is intended to create a contract.



    Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
  • CHECK OUT OUR SIMILAR JOBS

    1. Developer Jobs
    2. DBA Jobs