Sybase DBA - Full time - CA

  • DOE
  • Pasadena, CA, USA
  • Permanent, Full time
  • The Resource Collaborative
  • 06 Sep 16

Our client is a top fixed income asset management firm located in sunny southern California. They only hire "the best " so this is a fabulous opportunity to join their talented technology team on the front lines of "trading places "!

You will be responsible for architecture, deployment and maintenance while supporting database solutions for large scale Oracle databases in an effort to meet front, middle and back office application requirements within a fixed income environment. This consists of design, administration and production tasks including database architecture, tuning, monitoring, and backups and resolving production issues. Ability to support Sybase database applications and related systems.


Responsibilities/Duties:

  • Architect Scalable and High Availability Solutions for large databases with heavy transaction and batch activities
  • Build and Maintain Oracle Real Application Clusters
  • Support production - mission critical systems and maintain application functionality
  • Perform Oracle and Sybase administration - dumps & loads, user account maintenance, device management, manage tables, constraints and indexes
  • Maintain existing environment, perform upgrades & resolve technical problems
  • Support of development group & activities while working with application development groups,designing the database architecture to meet application needs
  • Help the application team with SQL Tuning
  • Daily server maintenance and monitoring; database health checks
  • Capacity and Scalability Planning and Database physical design
  • Setup Database monitoring and maintenance and integrate with enterprise management infrastructure
  • Evaluate tools & new product releases, researching features & engineering
  • Will design, architect databases in support of development initiatives
  • Support related Sybase databases

Competencies:

  • Senior technical expert level knowledge of Oracle with minimum of 5-8 years experience with designing, deploying, administering and supporting Oracle Databases within fixed income and/or related financial services firm
  • Recent hands-on experience with 10G databases (Clustered with ASM)
  • Minimum 2 years hands-on experience of deploying and supporting Real Application Cluster (RAC).
  • Minimum 4 years experience with data replication technologies (Experience of Oracle Streams is desirable)
  • Minimum 3 years experience UNIX shell scripting and/or Perl Scripting
  • Experience on architecting and implementing high availability solutions
  • Good knowledge of PL/SQL and SQL tuning
  • Good interpersonal and communication skills
  • Superior troubleshooting skills
  • Exposure to other RDBMS systems such as Sybase and SQL Server
  • Sybase or SQL Server migration to Oracle
  • Oracle Grid Control Concepts & experience with grid configuration & administration
  • Senior technical expert level knowledge of Sybase and Sybase databases - processes, data, management of devices, backup and recovery
  • Working knowledge of Solaris/Unix operating system, commands, utilities, file systems, basic scripting

Academic Qualifications (minimum requirements):

  • Undergraduate degree in related discipline (e.g., information technology, engineering, database technologies, etc.).
  • Oracle certifications
  • Unix SA knowledge
  • Sybase certifications