Responsys Careers



MS SQL Server/ Oracle Database Administrator

The MS SQL Server/ Oracle Database Administrator position will be working with the Product Support Team at our Head Quarters in San Bruno. This position will require 24/7 on call support after business hours which is based on a weekly rotating schedule.

Job Description:

  • Monitor and troubleshoot Microsoft SQL/ Oracle Database performance and scalability issues
  • Perform upgrades and migrations
  • Implement backup/recover procedures for new and existing environments
  • Periodically perform backup/recovery dry run to validate the backup/recover procedures
  • Develop Database Administration automation scripts
  • Develop and maintain ETL processes to support the data warehouse on Microsoft SQL Server
  • Interact with the Customer Support and Professional Services Organizations in the capacity of Tier 2 Support for Customers.
  • Provide technical and business guidance for complex user problems
  • Identify and develop tools to assist in Production Support and Operations ability to troubleshoot Database and application related issues
  • Document Standard Operating Procedures for Production Support/Operations team
  • Provide design assistance to Engineering for new and existing releases
  • Attend weekly team meetings and participate team building activities

Qualifications:

  • Intermediate to expert experience of Microsoft SQL server with OLAP experience
  • Intermediate to expert experience in datawarehouse environments
  • Basic understanding of Oracle 9i and 10g RDMS on Sun Solaris plus knowledge of Oracle BDA best practices
  • Intermediate understanding of SQL Server OLTP and Data Warehouse databases
  • Scripting experience in any standard shell script such as unix shell, c-shell, perl and bourne
  • Windows Batch Scripting to automate database administration tasks
  • Microsoft Stored procedure, PL/SQL, SQL Loader and SQL experience
  • Experience in high availability, 24/7 production environment
  • Experience with SAN (i.e. EMC), NAS (ie. NetApp, StorNext), and iSCSi (i.e. Dell Equallogic), Informatica ETL a plus

Contact:
Gregg Hansen
Sr. Recruiter