Percepta
Senior Database Administrator
At a glance
Location: US-FL-Melbourne Map
Posted: 01/13/2020
Closing: 02/12/2020
Degree: 4 Year Degree
Type: Full-Time
Experience: At least 10 year(s)
Percepta
Job description
­­Expect more than a job.

Our values are the heartbeat of our organization and we live, breath and play by them every day. Join our team as a Sr Database Administrator and experience the satisfaction of being part of a unique culture. As a Percepta team member, you can expect 

 
  • Culture of Service - to be treated like you are the customer from day one
  • Teamwork – belonging to a supportive family team environment that encourages growth, fosters trust and open communication and acknowledges value in your contributions
  • Respect – a team that is accountable, dependable and gives you their full attention
  • Proactive – to surround yourself with solution-oriented people who strive to improve themselves, others and the organization
  • Career growth and lots of learning opportunities for aspiring minds
  • Diversity - be a part of our growing diverse and community-minded organization that is all about having fun!
  • Competitive compensation – we take care of family, which is why we offer more than just competitive wages and great benefits. Our programs offer incentives and promote physical, mental, and financial wellness.
Position Summary

Responsible for Percepta’s Oracle & SQL Server databases and providing DBA support or enhance those servers and databases.  Other duties include remote site software installation, database configuration, monitoring, tuning, implementing of application and backup/recovery of databases.

Duties and Responsibilities
  • Experience in Oracle on AIX/Unix/Linux and SQL Server

  • Spec hardware and software’s for existing projects, new projects and future databases and make recommendation to upper manager.

  • Create, document and implement database policies and procedures

  • Perform database installations, upgrades, patching of both Oracle & SQL Server databases.

  • Perform off-site database installation, upgrade database to Cloud Environment and assist with new technologies.

  • Design and Implement: - For Oracle-- RMAN, DataPump, DataGrid, EM, UAC, Profiles, LogMiner, ETL Jobs.

    SQL Server – Support SQL backends along with SSRS, SSAS and SSIS projects and environments. Manage SQL security, backups, maintenance and performance monitoring.

  • Knowledge of Data Warehouse and BI environments of benefit.

  • Well versed in Unix/AIX Shell Scripting and experience in Windows PowerShell.

  • Design and implement database maintenance routines to minimize the downtime to end-users. 

  • Design, Implement and Maintain Data Loads to the Datawarehouse.

  • Design, Implement and Maintain Oracle Partitions and Partitioned Indexes.

  • Design, Implement and Maintain ETL processes to the DataWarehouse

  • Design and Implement Data Transfer routines from Prod to QA/Dev Databases.

  • Implement, Refresh, Backup and Maintain Cubes & Dimensions on SQL Analysis Server

  • Monitoring/resolving the day-to-day performance issues, errors, etc.

  • Troubleshoot/resolve application, connectivity, functioning and slowdowns.

  • Review and implement new changes to the databases to incorporate new business logic.

  • Performance monitoring of the various application and databases.

  • Provide technical guidance to DBAs, application developers or end-users as needed.

  • Ensure compliance with vendor software license agreements

  • Audit remote site servers and databases to ensure policy and procedures are adhered to.

  • Answer user question and assist our customer when requested.

  • Adhere to service level agreement.
  • Complete other duties assigned by the DBA Manager.

  • Must be able to work 24 x 7and weekends due to maintenance schedule.

     
Education
  • Bachelor’s Degree from a four-year college or university OR ten years related experience and/or training

Experience
  • Ten (10) years plus of Database Administrator experience (DBA)

Job requirements

     Must have Senior Level working knowledge and expertise on the following: -

  • Experience with configuration, installation, upgrading, patching, maintenance & Backups for Oracle 11g and 12c databases

  • Experience with configuration, installation, upgrading, patching, maintenance & Backups for SQL Server and Analysis Server

  • Experience with database security, user access and database privileges

  • Experience in Performance and Tuning of Databases including the complex Datawarehouse queries, views and reports.

  • Experience in Oracle Partitioning, IOT, Materialized Views, Table/Index reorgs.

  • Experience in Designing and Implementing ETL routines for Datawarehouse.

  • Experience in PL/SQL & TSQL programming and troubleshooting.

  • Experience with Oracle/SQL Server Backup & Recovery including Custom Scripts, RMAN, Datapump & SQL Loader

  • Experience in troubleshooting and resolving urgent/critical incidents on production systems

  • Experience with IBM AIX/LINUX Server operating systems.

  • Experience in IBM AIX Infrastructure, AIX Shell Scripting and Windows PowerShell Scripting.

  • Experience with Oracle enterprise manager and SQL server management studio

Other
  • Must be able to travel 10% of the time

 

Percepta requires all employees hired in the United States to successfully pass a background check and depending on location and client program a drug test, as a condition of employment. Percepta is an Equal Opportunity Employer.

 
Senior Database Administrator