Database Administrator

Computers/Software Vienna, Virginia


Description

 

Horizon Industries Limited (HIL) is a dynamic IT and Management Consulting firm based in the Washington, DC area. We are currently seeking a Database Administrator for a full-time position in Vienna, VA supporting the Federal Transit Administration.

Job Description:

This position will be responsible for providing support to all solutions currently on or planned for integration into the Client’s environment of its suite of applications. The current platform leverages one shared MySQL database in a cloud environment servicing multiple applications.

 

Duties of a Database Administrator may include:

  • Support planning and integration oversight across the platform
  • Analyze the existing database schema and provide suggested logical or best practices changes that will improve performance or scalability across the platform, ensuring normalization, referential integrity and auditing
  • Review pending data/database changes in development for the platform for both existing and pending applications to advise logical data/database standards and to implement those standards as approved by the Client
  • Facilitate information gathering session with both business and technical experts to provide the best database design
  • Creation of data migration plans and implementation of associated data migration activities
  • Migration of legacy system data into modern platform and data warehouse environment
  • provide maintenance, development, and analytical support of the database and its datasets
  • Proven expertise in writing, testing, and optimizing database stored procedures
  • Data migration and associated methodology and documentation expertise across multiple database software types
  • Support development initiatives with database design expertise, data/ database testing, data architecture compliance review, and data/ database documentation support
  • Support data/ data query support for any audit reviews of the platform

 

 

Required Skills / Experience:

  • Key lead for data architecture and design production system
  • Designed, implemented, evaluated, and standardized SQL Scripts and stored procedures
  • Developed and managed data architecture policies and database management standards
  • Designed, implemented, and evaluated Data Migration Plans
  • Demonstrated skill with Data Migration Activities including data manipulation and transformation
  • Managed data models, created data dictionaries, and designed Entity Relationship Diagrams
  • Experience using Cloud services, Erwin, and MySQL Databases

 

Required Certifications:

  • MySQL Database Administrator (preferred)

 

Education: N/A

Location: Vienna, VA

Horizon is an Equal Employment Opportunity employer and it is our policy to consider all applicants for employment without regard to sex, race, color, creed, religion, national origin, sexual orientation, marital status, age, disability, veteran status, alienage, ancestry, citizenship status, or any other factors prohibited by law. Horizon will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Horizon’s legal duty to furnish information.

EOE M/F/D/V