NEC Arlington , VA 22201
Posted 2 months ago
Location: Arlington, VA
Responsible for oracle database administration in a mission-critical , 24/7 environment. Provides technical support for solution delivery including analysis, design, evaluation, configuration, installation, documentation, testing, training, and general support across the functional areas of the solution offerings. This individual will be responsible for providing DBA services to application development teams, support multiple database environments, and manage the build-out of database infrastructure. Involves in troubleshooting the OS, RDBMS and proprietary application issues and documenting the procedures.
Responsible for database administration of production databases.
Responsible for quarterly patch deployment (PSU) and periodic database upgrades with minimal downtime in database environment.
Responsible for database backups, design, development, testing, and performance tuning.
Monitor and address database alerts/issues, capacity constraints, and performance related items.
Implement Database automation or scripting to automate various DBA tasks.
Required to participate in 24x7 on-call rotation and be available to perform periodic after-hours support.
Experience on Relational Database management systems MS SQL, MySQL and with No-SQL DB systems is an added plus
Investigate, assess, and make recommendations for new technologies
Work with tech leads and other engineering leaders to build resource utilization estimates
Knowledge of standard methodologies related to security, performance, and disaster recovery.
Maintain database baseline configuration documentation, including security controls, profiles, role, etc.
Setup/Support for Data-Guard. Verify backups and regularly test restore capability.
Bachelor's Degree with a minimum of 8+ years of experience performing Oracle Database Administration & Tuning.
Experience in installation, maintenance and troubleshooting of Oracle database (12c & 19c)
Experience on Oracle 12c & 19c RMAN, Data Guard, ASM, Standby Database setup and Management.
Expertise in Oracle RAC, Oracle Data Guard and Oracle stand-alone administration
Experience in deployment of PSU & Bug fixed Patches in rolling fashion.
Experience in Performance Tuning using EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, AWR and ADDM.
Knowledge & experience on Different Backup methods and backup tools is needed.
Experience in handling high availability systems - Oracle Data guard / Physical & Logical Standby databases
Experience in working & configuring ASM and manage issues related to ASM
Experience in identifying top queries, top sessions and Performance Tuning
Should have knowledge & experience in Unix command and writing shell scripts
In-depth knowledge of partitioning, RMAN, Grid Control and Oracle Enterprise Manager
Assess project risks, quantify risk/benefit relationships, and provide alternative solutions and risk mitigation.
Experience in site reliability engineering including SLOs, SLIs, building SRE tools
Experience in incident, problem and change management practices
Certifications: Certifications related to Oracle, Azure, AWS and RedHat is an added advantage.
Specialized Knowledge and Skills
Communication Skills: Highly developed communication skills: the ability to interact effectively with people across the enterprise and within customer organizations to accomplish assigned tasks.
Reasoning Skills: Problem analysis and problem resolution at both a strategic and functional level.
Technical Skills: Knowledge and experience with AWS, Azure, and on-premises systems. Experience in scalability, failover, high availability, capacity planning, security, and compliance.
Supervisory Responsibility, if any: None
ABOUT NEC CORPORATION OF AMERICA
Headquartered in Irving, Texas, NEC Corporation of America (NEC) is a leading technology integrator providing solutions that improve the way people work and communicate. NEC creates the social values of safety, security, fairness and eciency to promote a more sustainable world where everyone has the chance to reach their full potential.
With a global team of 100,000, and 64,000+ technology patents, we deliver one of the industry's strongest and most innovative portfolios of communications, analytics, security, biometrics, and technology solutions that unleash customers' productivity potential. Through these solutions, NEC combines its best-in-class solutions and technology to solve today's most complex business problems. NEC Corporation of America is a wholly owned subsidiary of NEC Corporation, a global technology leader with a presence in 140 countries and $27 billion in revenues. Backed by 123 years of innovation and experience, NEC knows what it takes to change and stay ahead of technology's continuous evolution. It is our capability to leverage decades of award-winning technologies and research that has enabled NEC to remain an Information and Communications Technology (ICT) leader and through problem resolution, bring new value to people, organizations, and society.
NEC Corporation of America and its subsidiaries is committed to the maximum utilization of all human resources and the goal of Equal Employment Opportunity/Affirmative Action. We provide equal opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, marital status, disability, genetic characteristics, height, weight, arrest record pertaining to misdemeanors or status as a Vietnam era or special disabled veteran, or any other class protected by applicable federal, state, or local laws.
EOE-Minorities/Females/Protected Veterans/Individuals with Disabilities.