Database Administrator III

Location: Reston, VA


PRIMARY EXPERIENCE REQUIRED
- Physical Data Modeling experience is a must. Past experience on MPP platforms such as Netezza/Redshift/Teradata/Exadata is preferred
- "HANDS-ON" big data experience, particularly with acting as DBA/Engineer on Hadoop Schema-On-Read and RBAC (Hive, Ranger).
- Experience with Javascript and Javascript packages such as D3.
- Experience working with JSON
- Experience working in AWS Cloud environment highly desired (S3, EMR, RDS/PostgreSQL, Redshift, DMS)
- Physical Data Modeling experience is a must. Past experience on MPP platforms such as Netezza/Teradata/Exadata is preferred
- Experience with S3 and file storage designs such as Parquet, Avro, CSV, etc.


Cloud specific skills:
• Experience with Hive, Athena, Redshift (including Spectrum), Amazon RDS, and Glue Metastore
• Experience building cloud infrastructure
• Unix scripting to support operations automation
• Solid knowledge of AWS platforms and services, including but not limited to AMIs, EC2, S2, IAM, AWS CLI. AWS Certifications are a plus.


TOP SKILLS Needed:
1. General Data Modeling experience
2. "HANDS-ON" big data experience
3. Strong Communication (written & verbal)

Job Responsibilities:

  • Provide on-site database and system support

  • Monitor, collect statistical information, and provide reporting on capacity and system performance

  • Based on statistics, make recommendations to maintain and improve capacity and system performance

  • Monitor the system, and act upon system and application automated alerts

  • Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)

  • Plan and perform software installation, configuration, upgrade and patching

  • Plan and perform database configuration, maintenance, upgrade and patching

  • Perform and manage system and database backups

  • Perform manual switch to redundant system / database components, in case of system failure.

  •  

  • Education/Experience:

  • Bachelor's degree in a technical field such as computer science, computer engineering or related field required

  • 10+ years experience required

  • Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution

  • Strong knowledge of SQL

  • Understanding of Help Desk tools and trouble ticket tracking processes

  • Understanding of support agreements and their implied service levels

  • Proven ability to write excellent technical documentation