DBA - 3522

Metro Systems, Inc. is seeking a database administrator, team lead for our client on-site in Richmond, VA.

Job Summary

  • The responsibilities of this position expects the candidate to learn and understand current Microsoft SQL and Oracle database, their relationship to applications and web-services, along with the data used for OLTP , OLAP and Lookup tables. Understanding of indexes, store procs, optimization and performance tuning
  • The responsibilities of this position will include working with database administrator, developers, business analyst and IT management, to understand company data needs, maintaining data integrity, help DBA’s manage data, and follow company data retention policy.
  • The responsibilities of this position also include the design, development and distribution of data in form of reports or data cubes to support company reporting and analytic needs from data warehouse.
  • This position includes database tasks, and includes development tasks that automate the current process and operations using .NET.
  • Involved in creating and maintaining the ETL process.
  • Ensure meeting SLA requirements of various IT operations process.
  • This position will require managing the time and deliverables of the onsite team including vendors and offsite distributed team.

Duties and Responsibilities

  • Continuously exhibit and uphold Core Values of Integrity, Accountability, Communication and Teamwork, Innovation and Customer Service
  • Work with DBA OPS staff to keep production and UAT database in sync.
  • Work with development and database team to review production and business user databases to ensure data integrity across databases
  • Provide weekly and regular project / task update with action items.
  • Ability to plan a project and its deliverables.
  • Partner with Business Analysts, Database Administrators, and developers to build out data marts to support changing business needs.
  • Participation in design, development, testing and implementation of new projects or sustaining current applications
  • Act as the liaison between DBA and Development, Network , BA, Helpdesk team.

Knowledge, Skills and Abilities

  • Have working experience of database such as MS SQL 2008 R2 and above; Ability to learn and work with Oracle 12c and other database
  • Ability to decompose high level data concepts into understandable details and communicated/discuss these details with appropriate parties (including but not limited to business analysts, developers, project managers, and select non-IT data users).
  • Strong understanding of reporting solution concepts and strategies, including types of data and the relationships; SDLC; security access; performance; data usage guidelines
  • Proficiency in Microsoft Reporting Services, Microsoft Query Analyzer, PL/SQL, SQL Developer
  • Have lead a team of developers or dba in the last 2 years.
  • Have lead production support and operations tasks.