This is a high profile role for technical operations candidates to join a Managed Service (MS) and ASP within a major software house.
The right candidate will be a member of the growing MS team with key responsibilities in service engagement with our MS clients.
The ideal candidate must be conversant with operational Unix commands and procedures around the management of a secure data network, the physical servers and environments will not be at our site and will be physically managed by third parties, we are responsible for managing some of the infrastructure components as well as all of our applications running at the those sites.
We are looking for bright, articulate candidates with strong drive and capability to learn and expand their current knowledge.
Working as a team covering up to 24x7 hours the candidates must exhibit a high degree of professionalism including the ability to escalate when needed, a desire to provide high customer satisfaction and be reliable.
The range of equipment and applications to be managed will also be expanding. Much of the expansion will be on Linux based platforms.
Your duties and responsibilities
Work with the ASP and client service operations staff to help with customer database issues and deal with standard operational activities for production systems
Create maintenance plans and jobs, backup and recovery, user accounts, database log space monitoring, and maintenance on mission critical database systems
Co-ordinate with development team and conduct fine tune performance using combination of database optimization, queries and automated workload repositories (AWR) for both development and production database systems maintained at data centre
Enforce security and access control across all database servers in the network
Research and implement hardware specifications for cluster setup, load balancing and shared storages
Contribute to overall capacity planning and configuration management of the supporting infrastructure
Create DB recommendation for production and development environments Your skills, experience and qualifications
Bachelor’s degree or equivalent in related field required
SQL / Oracle certified DBA
2-4 years of experience as DBA in production and development environments
Strong troubleshooting skills
Must be a team worker with outstanding communication skills, both oral and written
Ability to work independently on multiple tasks with minimal guidance
Ability and desire to work in a fast paced environment
Attention to detail
Excellent work ethic, dependable and responsible
4 years of experience using SQL server
Experience in writing and analyzing complex SQL (stored procedures, triggers, etc.)
Experience with data modeling tools
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Oracle and MSSQL Server
Knowledge of indexes, index management