Share this Job

Go Back

Database Administrator Sr Location:Smithtown, NY

,
2017-04-04 23:37:25
Job Type: Full Time only

Role:Database Administrator Sr

Location:Smithtown, NY

ESSENTIAL FUNCTIONS

  • Manages and maintains all production, non-production and DR databases.
  • Analyzes and supports database systems that tend to be of broader size and scope and of significant impact within a business context.
  • Implements and/or integrates databases and/or client requirements related to databases requirements.
  • Responsible for standards and design of physical data storage, maintenance, access and security administration.
  • Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
  • Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
  • Performs work that is highly complex and varied in nature.
  • Develops integrated solutions to resolve highly complex technical and business issues.
  • Defines and discerns key aspects of a problem and develops an integrated solution within a broad technical and business context of significant impact.
  • Provides guidance/training to more junior staff. Requires technical and business knowledge in multiple disciplines/processes.
  • Consults with and advises users on access to various databases. Works directly with users to resolve data conflicts and inappropriate data usage.
  • May generate scripts for administrative functions, devise sample test data, and run associated tests.
  • Directs the maintenance and use of the corporate data dictionary.
  • Adheres to polices, procedures and standards. Recommends changes in procedures.
  • Ensures the accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties.
  • Creates estimates and determines resource requirements for assignments and tracks progress against major milestones.
  • Prepares status, and special analysis reports using project management methodologies.
  • Participates in customer/user meetings as required. Maintains industry knowledge and participates in technical training as recommended or required by Manager.
  • Performs special projects and additional duties and responsibilities as required.
  • Where applicable and when performing the responsibilities of the job, employees are accountable to maintain Sarbanes-Oxley compliance and adhere to internal control policies and procedures.

EDUCATION AND EXPERIENCE

  • Bachelor\'s degree in information technology or technical institute degree/certificate or equivalent application development experience.
  • Certification in (or near completion of) Database Management Systems (DBMS) preferred. Minimum of five years of experience as a Database Administrator.
  • Minimum of ten (10) years of IT work experience including managing team(s) responsible for SQL & Oracle database administration and support.
  • Experience with web-enabled enterprise applications, protocols and standards.
  • Experience deploying and supporting databases in a virtual environment.
  • Extensive experience with SQL and Oracle vulnerability, hardening and patch management, including risk remediation. Experience supporting agile project initiatives.
  • Experience with SQL programming such as T-SQL, including SQL queries, stored procedures & views.
  • Application cluster experience required.
  • Demonstrated experience in database administration, Microsoft SQL & Oracle.
  • SQL Server 2008 R2 thru SQL 2016 and Oracle 12C. Proven experience in IT infrastructure planning and development.

KNOWLEDGE, SKILLS AND ABILITIES

  • Expert knowledge of SQL & Oracle databases and the ability to obtain Microsoft SQL certifications.
  • Comprehensive knowledge of, and the ability to apply some advanced concepts, practices and procedures used in designing and managing a database environment.
  • Strong analytical and organizational skills.
  • Excellent project management skills.
  • Strong verbal and written communication skills, good negotiation skills.
  • Detail oriented. Self-starter with positive initiative


Key Skills:
N/A