Sr. DBA

» Sr. DBA
Information Technology
in Hartford
, CT
Reference: 19-04118

Job Description:

The Database Administrator is responsible for setting up, managing, and optimizing databases in support of Enterprise and External Web applications. This includes working closely with system managers and developers to add system functionality, tables, and data; optimizing systems for availability and performance; and contributing to system upgrades. The Database Administrator also is responsible for maintaining applications, processes, and maintenance procedures; performance tuning; and documentation and management of changes to database operations.

Essential Duties and Responsibilities:  

  • Setup, configure, and install database systems
  • Optimizes and tunes database systems
  • Proactively monitors performance and capacity
  • Performs data ports and data loads; monitors and tests data integrity as required
  • Backup, recovery, testing of recovery procedures, and archiving databases
  • Troubleshoots database issues and performs database impact analysis for proposed changes
  • Ensures that systems stay updated on all relevant patches and upgrades
  • Alter tables and schema structure as required
  • Serve as technical expert for database design and support issues
  • Works with the Application and Internet Development teams to develop stored procedures, triggers and code to support enterprise applications as well as to enforce coding standards
  • Executes database release management processes and coordinates maintenance of development, testing, and production environments
  • Automates manual processes when practical
  • Mentors less senior Database Administrators

Performance Skills/Competencies

Education:

  • Bachelor’s degree (B.A.) from four-year college or university

Knowledge:

  • Having wide-ranging experience
  • Uses professional concepts and company objectives to resolve complex issues in creative and effective ways
  • Some barriers to entry exist at this level, at which a career may plateau

Job Complexity:

  • Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors
  • Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results
  • Networks with key contacts outside own area of expertise

Supervision:

  • Determines methods and procedures on new assignments and may coordinate activities of other personnel

Experience:

  • Typically requires a minimum of 8 years of related experience

Language Skills:

  • Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals
  • Ability to write routine reports and correspondence
  • Ability to speak effectively before groups of customers or employees of organization

Mathematical Skills:

  • Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume
  • Ability to apply concepts of basic algebra and geometry

Reasoning Ability:

  • Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists
  • Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form

Certificates, Licenses, Registrations:

  • Microsoft DBA Certifications and Training preferred