Senior Database Admin (Oracle DBA, Equity Plan solutions)

  • Full-time

Company Description

Insightsoftware is a growing, dynamic computer software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. At Insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for future Insighters who can demonstrate teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team!

The Equity Management team is growing fast, retaining an agile startup mindset but delivering enterprise solutions to the top players in the financial domain.  This is your chance to be part of a team that delivers high quality software that changes the way our customers do business while having fun at work.

Job Description

Production Database Support and related attributes are described below all requiring hands-on working experience in production support of Oracle/SQL server databases in a 7/24/365 environment:

  • Install, patch and maintain all Oracle and SQL Server databases.
  • Manage regularly scheduled backups and refreshes.
  • Manage Oracle and Sql Server disaster backup and recovery using tools such as RMAN and SSRS.
  • Tune all Oracle instance components including SQL and PL/SQL.
  • Able to quickly digest and resolve production related performance issues.
  • Tune all SQL Server instance components using tools such as Database Tuning Profiler.
  • Manage the implementation of technical controls to support and enforce defined security policies.
  • Responsible for documenting and maintaining a Disaster Recovery plan for each supported system/application.
  • Linux bash scripting.
  • Able to provide 24/7 on-call rotational duty and some week-ends

Non-Production Database Support and related attributes are described below. These Database environments include Development, Quality Assurance, Customer Support, Data Conversion, and various other internal groups.

  • Support multiple application and support teams with numerous on-going projects.
  • Provide DBA services to application development teams, including database design, database generation, coding, and performance related issues.
  • Be instrumental in researching, evaluating, designing, testing, recommending, and planning implementation of new versions of Oracle/SQL server database and database related tools.
  • Performs assessments and listens to internal customers to understand and anticipate their needs and determine their priorities in the context of the overall enterprise.

Qualifications

  • 5+ years with hands-on experience as an Oracle Database Administrator supporting both Production and Non-production environments
  • 3+ years of DBA experience working directly with Oracle versions 12 and above
  • Good to have 2+ years hands on experience with Microsoft SQL Server Database Administration versions 2012
  • Must have strong hands-on experience in coding, debugging and tuning Oracle PL/SQL and SQL.
  • Database tool experience in TOAD, DBVisit Standby, Zoho’s Manage Engine Application Manager and Solar Winds DPA or equivalents.

Desired experience in these areas:

    • Oracle Streams or Advanced Queuing
    • Oracle Application Express coding
    • MS SQL Server Databases
    • Linux System Administration.
    • Installation, setup and tuning of Linux running Oracle.
    • PowerShell scripting
    • Dell Servers (Hardware)
    • Azure Cloud (SaaS)
    • Azure Azcopy (upload/download)
    • Oracle on prem to cloud (oracle cloud/azure) migration experience
    • Oracle linux administration experience
    • Oracle instance configuration (memory, security, optimizer, etc)
    • Maintain Oracle security using tcps and encryption
    • Monitoring activities including verifying database operations status including tablespace, alert logs

Additional Information

All your information will be kept confidential according to EEO guidelines.

InsightSoftware is an Equal Employment Opportunity employer and as such does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other classification protected by applicable discrimination laws.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)