Database Administrator
Confidential
Total des années d'expérience :25 years, 1 Mois
As a DBA responsible for managing Production and Development database operations. Providing 24x7 Production and Development support and maintenance of all Oracle Database environments.
Responsible for implementation and effective management / functioning of Databases and IT Infrastructure Operations
Working closing with Project Teams on design, development and build of new production, staging test and development databases using some of the latest Oracle products
Key Responsibilities
•Administer and provide technical support for Production and Development database
•Administrative support include Database creation, Backup and Recovery, Security Management (create and maintain users and roles, assign privileges on different Schemas)
•Tested and upgraded the Production instance from 8i R1 to 9i R2 to 10g R2
•Performance monitoring and fine - tuning of the system for optimal performance and proactively plan to ensure that performance is maintained
•Performed general technical trouble shooting and give consultation to development teams
•Migration of database from Development environment to Production environment using Export / import
•Effectively carrying out database maintenance and support activities pertaining to Space Management, Schema Management
•Patch management and Version control
•Database backups being verified and restored on Development database
•Used Citrix Metaframe Server for publishing Oracle based applications
Use TOAD and PL / SQL developer tool as an aid for monitoring Production and Development database for Free space, Next extents
Bank of Bahrain & Kuwait \[Indian Operations
Implemented, Supported Treasury Management System (ITMS, ALM) and Banking System (NDS and RTGS)
Responsible roles
•Database administration and Technical support (24/7) for Treasury Management System and Banking database (ITMS, NDS and RTGS)
•Implemented multiple IT projects such as (ITMS, NDS and RTGS), provided technical knowledge to support organization’s business objectives.
•Implemented and supported flow of data through interface from Core Banking System (Finacle) to Treasury Management System (ITMS). Thus saved one - man Labor in the organization
•Coordinated and supported transfer of data from FoxPro based Treasury System to Oracle - based Treasury Management System (ITMS) during migration
•Coordinated hardware, software installations and upgrades to ensure work is performed in accordance with Banking policy
•Coordinated testing, upgrade and configuration of system services, ensure changes are in accordance with appropriate operating procedures
•Administrator support include database creation, backup and recovery, security management, database tuning and query optimization
•Participated in designing and implementing system disaster recovery procedures
•Maintained Support for Financial and Treasury database for Daily/Monthly and Yearly - Close
•Extracted data for Financial analysis project
•Designed and implemented backup and recovery procedure for Oracle database
•Installed, migrated Oracle RDBMS (8i/9i)
•Database backups being verified and restored on Development database
•Banking database setup/configuration/upgrade
NDS database upgrade project from Oracle RDBMS 8ITo 9i
Coordinated hardware, software installations and upgrades, ensure work is performed in accordance with banking policy
Determined proper installation plans
Other Miscellaneous Short - Term Work
•Assets / Liability Management (ALM)
Responsible roles
Generated flat files that capture data through SQL and PL/SQL tools from Core Treasury system ITMS
Data transferred to Third party tool for generating required reports
Report generated from the third party tool gave detailed analysis of Assets and Liabilities to the Management
•Non Resident Deposits Comprehensive Status Report (NRD CSR)
Responsible roles
Captured data from Core Banking software Finacle with the help of scripts generated through PL SQL
Data transferred to Third party software provided by RBI, which help them in analyzing and generating reports for Statistical financial studies
Bank of Bahrain & Kuwait \[Indian Operations
Responsible for management of IT Infrastructure for Mumbai region and main responsibilities were to ensure smooth running and security of the network and data infrastructure
Responsible roles
•Resolved operation difficulties including system failures, network errors, and batch malfunctions and resumed services within the shortest time possible and that all problems relating to operations are documented logged and reported to IT Manager and Service line
•Oversaw successful management of technology portfolio including operation and maintenance of servers, data storage devices, databases, data centers network, middleware, internet services and other Information Technology systems comprising the core infrastructure
•Ensured that all the changes to live systems have been tested i.e. conduct an Operational Acceptance Test (OAT) after User Acceptance Test (UAT) has been completed
•Ensured proper operations for End - Of - Day (EOD) / End - Of - Month (EOM) and Year - End procedures have been followed by maintaining checks through checklist and also ensured that all jobs are processed correctly as scheduled i.e. Begin of Day, Daily and Weekly Activities etc. and output is generated in accordance with the requirements
•Ensured that backups of all systems are done as per laid down procedures and ensuring that backup tapes are securely taken to Off - site location
•Coordinated with contractors and vendors and ensured that the delivery of Hardware and Software is made on time and ensured that adequate stock of auxiliary items to the computer equipment is maintained and Service Level Agreements (SLA’s) were upheld
•Managed and tracked all IT assets in full life - cycle, from installation to disposal, and created weekly, monthly, quarterly and yearly reports for Business Process management on the status and configuration of each of these assets
•Worked on Disaster Recovery Plan / Business Continuity Plan and kept it updated to reflect organizational, IT asset, and infrastructure changes
•Participated in semi - yearly testing of Disaster Recovery Plan / Business Continuity to verify the plans and ensure that everyone knew their roles in how to recover from one or more disasters
•Supervised and participated in maintenance procedures, ensuring security patches and hot fixes were deployed. Directed and ensured adherence to policies and procedures related to server, network, data center and disaster recovery operations
•Responsible for management and coordination with contractors for safety inspections, as well as all activities related to the facility and maintenance and upgrades that occasionally occur. This included all equipment related to power, security and fire protection
•Managed team of IT professionals that provided technical services for IT equipment installation, configuration and data networking and ensured that housekeeping for all the systems is done strictly according to schedule
Responsible for management of IT Infrastructure and main responsibilities were to ensure the smooth running of internal IT Infrastructure
Responsible roles
•Managed and controlled servers / desktops and configured hardware, peripherals, settings, directories, storage etc. in accordance with standards and project/operational requirements
•Installed and configured systems that supported GIS infrastructure applications
•Developed and maintained installation and configuration procedures
•Performed daily system monitoring, verifying integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, verifying completion of scheduled jobs such as backups
•Performed daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created and media is recycled
•Implemented VPN solution to enable secure connection between remote location and corporate headquarter
Responsible roles
•Supervised and maintained all computer equipment, hardware and software information to meet organizational needs
•Maintained documentation for multiple functional areas including applications training, technician coordination and scheduling
•Assessed organization's computer training needs and requirements
•Coordinated and implemented basic computer training and on - going education
•Overseen progress and effectiveness of training programs
Responsible roles
•Assisted in troubleshooting user problems relating to Operating System issues (Win9x, NT), Network Connectivity, TCP/IP configuration, upgrades
•Assisted on - site visits and hardware troubleshooting and local system and software upgrades
•Performed upgrades, installation of software and drivers and essential desktop troubleshooting
•Built a customer base by providing support on various messaging, software and training related issues to existing customers
•Designed in - house training and technical documentation for customer base
•Integrated Windows NT server into the network and managed the migration from an Banyan Vine system to Windows based system