Our Client is a well-known investment bank in Singapore.
Working location: Singapore, 5 working days
Design, develop, and implement complex physical databases across multiple platforms, technologies and computing environments.
Monitor the performance of databases and makes tuning changes. Oversee ongoing system capacity planning, forecasting, and tuning.
Perform research, prepare technical studies and make recommendations. Prepare business requirements reports, feasibility studies, and cost justification statements. Articulate information architecture to clients.
Consult with higher level resources to ensure consistency of recommendations with enterprise direction. Research and evaluate alternative solutions and recommend the most cost effective design solutions.
Work closely with technical and client management to ensure implementation of database management and support tools for complex business application development requirements and processes in accordance with latest enterprise direction (e.g., diverse development platforms, technological environments, software, hardware and tools).
Consult with IT staff and clients to determine the impact of new or revised applications on information architecture. Consult with clients to determine information management requirements.
Provide training and professional development on new technologies and applications to staff.
Provide development and production s upport in a 24 x 7 shop. After hour and weekend support is required.
Expert knowledge of Oracle 11g, 10g, 12C , EXACC and EXADATA
Expert knowledge of Oracle security.
Expert knowledge of UNIX - AIX, Solaris, Linux
Expert knowledge of with Oracle RAC, ASM, Data Guard, Oracle Clusterware, GoldenGate
Expert knowledge of RMAN backups.
Expert knowledge of UNIX shells - Korn shell, bash, perl.
Experience with SQL Server security framework and Active Directory
Experience using Database Vault, Audit Vault and ASO.
Experience using Grid Control monitoring tools.
Experience with SAN storage systems
Strong SQL skills . Ability to code packages and procedures.
Expertise in backup and recovery and fail-over methods and best practices.
Clear understanding of RDBMS fundamentals.
Ability to write clear documentation of operating procedures, and ability to write specifications for applications to be developed in relation to security components.
Exceptional communication, problem solving, and teamwork skills.
Extremely detail-oriented and able to follow clear methodologies for troubleshooting and development.
Ability to support and work within standard software development life cycle practices.
PeopleSoft Centric Technical Skills/Knowledge:
In-depth understanding of PeopleSoft architecture
Application server configuration and monitoring background
Process scheduler configuration and monitoring background
Experience with PeopleSoft Data Mover
PeopleSoft performance utilities and tracing options
PeopleSoft temporary tables use and performance aspects
PeopleSoft tablespace, table and index strategies
Knowledge of PeopleSoft metadata structure / objects
Understanding of PeopleSoft Messaging
PS Query experience writing and monitoring
Prepare your resume in word document (please include your current salary package with full breakdown such as base, incentives, annual wage supplement etc.) and expected package with your notice period (Including leaves to offset) and email it to firstname.lastname@example.org