SQL Server/Oracle DBA recruitment
Responsibilities
- Design and implementation of enterprise database architectures on MSSQL technologies
- Install, configure, manage and maintain multiple MS SQL and Oracle databases
- Manage Memory, CPU and I/O performance as well as assure database health
- Perform appropriate back up, restoration and upgrades of ours servers (including DR)
- Perform replication, clustering, performance tuning and optimization (query optimization, index tuning, caching and buffer tuning), Online Transaction Processing (OLTP), Data Warehousing, Online Analytical Processing (OLAP), High Availability, Load Balancing, patching of databases and applications
- Control operational procedures and support (including data modelling, replication, administration, maintenance, performance monitoring/optimization, SQL Tuning, capacity planning, space management and recovery)
- Evaluate specifications and requirements against available solutions
- Ensure system integrity and efficiency
- Recommend modifications for third party software products and act as a liaison to software vendors to meet user needs
- Ensure High Availability of the database systems: SQL Server backup Recovery, clustering, replication, database-mirroring and Log shipping. Knowledge on Oracle Data Guard and Oracle RAC would be a plus
- Ensure Recoverability of MSSQL databases: production and non-production. Maintain high standards of backup/recovery, conduct recovery tests
- Ensure best performance of the critical databases through efficient maintenance and performance tuning
- Write technical documentation
- Support and implement database changes, ensure quality of the changes
Educational Requirements
- Bachelor Degree in Finance, Economics, Engineering or Computer Sciences or equivalent experience
Knowledge Skill
- MS SQL Server 2000 / 2005 / 2008 R2
- Strong experience on database administration in SQL Server (2000-2008)
- Strong experience in supporting business-critical SQL databases, in a global environments
- Solid experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
- Expert experience in implementing operational automation
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively
- SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints )
- Oracle Database 10g / 11g
- Experience in managing Oracle databases, including installation, maintenance, and patch deployment
- Sound knowledge in administrating (RMAN), monitoring (Grid Control)
- Sound knowledge on supporting Oracle Data Guard, RAC
- Windows and Unix/Linux operating system - Unix OS: Solaris and Linux: commands, tools and utilities, scripting skills
- Database Security
- Database Networking
- OLTP (Online Transaction Processing) and DSS (Decision Support Systems), Data Warehousing, OLAP and ETL skills as well
- Experience on HA solution, including VERITAS Cluster / RAC / Windows Cluster
- Certified DBA a plus
- Ability to identify hardware/software interface problems to database
- Ability to use applications software, data structures, utilities, operating systems, and communication interfaces within the existing computing environment.
- Ability to perform systems and applications needs analysis on database
- Ability to communicate effectively, both orally and in writing.
- Financial experience would be a plus
- Knowledge of system/equipment capability, design restrictions, and security requirements.
- Strong problem solving and troubleshooting skills
- Anticipate/forecast critical points and make adjustments to deliver to commitments
Please apply to Will Feint at Confero.
April 13, 2012
• Tags: Information Technology careers in the Singapore, Oracle DBA recruitment, SQL Server • Posted in: Financial