Location: Remote – Central or Eastern Timezone
Oracle / SQL Azure Database Administrator
Must be authorized to work for any company in the US without Visa sponsorship or transfer.
Summary
Responsible for Oracle database and SQL Azure 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.
Essential Responsibilities
- 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 24×7 on-call rotation and be available to perform periodic after-hours support.
- Maintain database baseline configuration documentation, including security controls, profiles, role, etc.
- Setup/Support for Data-Guard. Verify backups and regularly test restore capability.
This list is intended only as a guide and summary of the typical functions of the position. It is not an exhaustive or comprehensive list of all possible responsibilities, tasks, and duties to which the employee may be assigned. An employee’s supervisor may ask the employee to perform additional duties or take on additional responsibilities without notice. This list is neither complete nor permanent and may be amended at any time in the Company’s sole discretion.
Basic Qualifications/Requirements
- Bachelor’s Degree with a minimum of 4+ years of experience performing Oracle Database and 2+ years Azure SQL Administration & Tuning or equivalent experience.
- Experience in installation, maintenance and troubleshooting of Oracle database (12c & 19c) and Azure SQL Server.
- Experience on Oracle 12c & 19c RMAN, Data Guard, ASM, Standby Database setup and SQL Server Management.
- Expertise in SQL Azure, 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, SQL performance monitor 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 and SQL Azure replication.
- Experience in working & configuring ASM and manage issues related to ASM.
- Experience in identifying top queries, top sessions, and SQL Performance Tuning
- Should have knowledge & experience in Windows OS, Unix command and writing shell scripts.
- Knowledge of partitioning, RMAN, Grid Control, Oracle Enterprise Manager, Azure cloud and SQL Server.
The anticipated salary range for this position is $110,000 to $120,000; depending upon the selected candidate’s relevant experience, the exact salary for the role may fall outside of this range. This role will also be eligible to participate in the Company’s bonus/incentive program(s). NEC offers an extensive benefits program and the role will also include, a Health Insurance package with options that include multiple Medical and Dental coverage options, Pharmacy Insurance, Vision Insurance, Life and Accidental Death and Dismemberment Insurance, Salary Continuation and Voluntary Long-Term Disability Coverage, an Employee Assistance Program (EAP), Adoption Assistance Program, 401(k) with a 50% match up to 6% of employee contribution, 15 PTO days, 10 paid sick days, 11 paid public holidays, Continuing Education and Tuition Reimbursement, 2 paid Community Service Days, a Travel Assistance Program and Pre-Paid Legal plans.
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 efficiency 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.
Specialization Description
IT Database Administration work includes designing, configuring, and managing databases to ensure the integrity, security and accessibility of the organization’s data including:
- Defining standards for physical data storage, maintenance, access and security administration
- Performing backup and recovery using Database Management Systems
- Configuring database parameters and defining data repository requirements, data dictionaries, and warehousing requirements
- Designing and implementing approaches to improve database performance, capacity, and scalability
Level Description
Senior level professional that applies advanced knowledge of job area typically obtained through advanced education and work experience. Works independently applying an advanced knowledge of a job area typically obtained through advanced education and work experience. Works to achieve results in a job area, overseeing and managing projects/ processes independently with limited supervision. Problems faced are difficult and are sometimes complex, though are routine. Coaching and reviewing the work of lower level professionals.