SAP HANA Database Administrator (Federal Government/Department of Defense)

Job Title:- SAP HANA Database Administrator (Federal Government/Department of Defense)

Location :: Herndon, VA [hybrid,3-4 days/week onsite]

Duration :: 12 months CTH

Experience :: 12+ years

MUST HAVES:

• Bachelor of Science in Computer Science or related field.
• Minimum 5 years of experience as a Database Administrator.
• Minimum 3 years of experience as an SAP HANA Database Administrator.
• Department of Defense, Federal Government, and Intelligence Community clearance and/or project experience.

Job Skills:

• The dba should have excellent troubleshooting and problem-solving skills.
• The candidate should have the ability to quickly analyze /search log and trace files and extract relevant data .
• The dba should be proficient in SQL and DB procedural languages and should write queries quickly to retrieve data.
• The candidate should be familiar to scripting languages and the Linux environment.

Please provide a MS Word resume and quantify the following number of years and projects and list clients and certifications

Job Qualification-

Department of Defense number of years

Federal Government number of years

Intelligence Community number of years

Database Administration number of years

HANA Installation/Data Provisioning/Administration/Modelling number of years

HANA Security Mechanism/Monitoring Yes/No

HANA Database Management Yes/No

HANA Cloud Migration Yes/No

HANA Perform Takeovers/Failovers Yes/No

HANA Lifecycle Phases (including planning, installation, configuration, patching, change-management) Yes/No

HANA Backup/Recovery Planning Yes/No

HANA Performance/Tuning Yes/No

HANA High-Availability/Disaster Recovery Yes/No

HANA Database Trace utilities/log-file analysis Yes/No

HANA Studio Yes/No

HANA DBA Cockpit Yes/No

HANA User/Role Management Yes/No

HANA Grants Verification/Audits Yes/No

HANA Audit Policies/Logs Yes/No

HANA Workload classes/kill scripts Yes/No

HANA Integration w/ remote systems Yes/No

HANA Predictive System Warnings/Metrics Yes/No

SAP HANA Database Administrator for {list client(s)}

Certification [list certification(s)]

Job Responsibilities:

• HANA DBA would be responsible for maintaining HANA Databases.
• HANA DBA would be responsible for migrating data to HANA cloud.
• The DBA will be responsible for performing takeovers and failovers and performing periodic disaster recovery tests.
• The DBA will be part of the technical team supporting all HANA environment lifecycle phases including planning, installation, configuration, patching, change-management, as well as backup and recovery planning.
• The candidate will provide technical expertise for HANA performance and tuning, as well as ensure all HANA systems maintain smooth operations through high-availability and disaster recovery.
• The candidate will be responsible for database troubleshooting, problem solving, application capacity planning, and optimization of database resources.
• The candidate is required to have strong database troubleshooting skills - performance tuning, patching, provisioning, and high-availability of HANA systems Monitor Hana Databases, setup alerting and automating the monitoring processes and data modeling.
• Experience using database trace utilities and trace log-file analysis Use HANA studio, DBA cockpit, analyze traces and dumps for memory and CPU consumption.
• Experience in managing users and roles in SAP HANA system, verifying grants & running grant audits.
• The DBA will be responsible for creating audit policies and querying audit logs to reconstruct past events.
• The DBA will be creating workload classes, kill scripts , deploying and tuning thresholds for alerting.
• HANA Installation, Data Provisioning, Admin, Modelling. Implementing SAP HANA Security mechanism, and monitoring of HANA system. Integration of SAP HANA into different remote systems.
• Ability to configure predictive system warnings and monitor metrics to avoid unexpected system outages.
• Running and troubleshooting SQL scripts and ability to understand procedures, functions, triggers.
• Candidate should have good verbal and written communication skills to enable joint troubleshooting sessions with disparate teams.
• Demonstrated subject-matter expertise with HANA HA & backup and recovery methods and tools.
• Flexible schedule which may include weekend or after-hour work