Ishant Arora
Angestellt, Database Administrator, Singlife Pte Ltd
Choa Chu Kang, Singapur
Über mich
Ishant has 9.7 years of professional IT experience in Database management, Administration and Engineering : Databases (SQL & NOSQL): Oracle (10g, 11g, 12c, 19c), MS SQL (2008,2012,2016,2028), PostgreSQL (9.x,12.x,13.x,14.x), MYSQL (5.x), Mongo DB (3.x, 4.x), DB2 (9.x, 10.x) Expert Knowledge of Database architecture and experience on RAC, Data guard, Golden Gate, High Availability (Master-slave), Always -On Availability, Clustering DB Management Skills: Configuration, Setups, Upgradation, Migrations, Data Streaming & Mirroring, Tech Refresh, Data Reporting & Analysis, Patching, Data Security Cloud Computing: AWS, Azure, GCP OS Platforms: Windows, Unix , Linux , Solaris Scripting: PL/SQL, Shell Script Programming Languages: Java, Python Database engineering tools: Kafka, PySpark, Hadoop/Hive CDC Tools: IBM Infosphere, Snowflake (AWS), Data Analysis Tools: PowerBI Domains: Tech, e-Commerce, Banking, Fintech, Software development, Product / Manufacturing, IT Service
Werdegang
Berufserfahrung von Ishant Arora
Bis heute 1 Jahr und 7 Monate, seit Dez. 2022
Database Administrator
Singlife Pte Ltd
• Responsible for Migration Projects from On-Premises to AWS RDS. • Supporting DB instances on AWS and VM Ware platforms. • Supporting Data refresh and CDC mirroring requests. • Responsible for performance management and tuning at the SQL/DB Level. • Supporting Developers and End users for Data related requirements. • Taking care of RAC instances (Exadata Machines) to keep everything as expected. • Supporting DB admin tasks. • Performing Change requests on the existing environment as per the requirement
2 Jahre und 2 Monate, Nov. 2020 - Dez. 2022
Senior Database Administrator
Lenovo PCCW Solutions Pte Ltd
Key Deliverables: • Taking care of Day to Day DB activities and requests from Application team and users on RAC, Data Guard, ASM • Supporting Multiple clients as a Database Administrator and consultant. • Supporting Activities like DB Backup & recovery, Upgradation, Migration and New installations / Setup • Performing patching activities on Oracle, Exadata and MSSQL systems. • Responsible for performance management and tuning at the SQL / DB Level. • User Management, Space management and Data Security
1 Jahr, Dez. 2019 - Nov. 2020
Application Support Engineer
NTT Data Singapore Pte Ltd
• Taking care of Application and database issues and requests. • Provide expert knowledge of Database and performance tuning • Taking care of Data issues, restorations to provide data / analytics • Performing Database changes and configuration as per requirement • Setting up database monitoring scripts and alerts. • Responsible for Daily or weekly maintenance activities • Dealing with Middleware, Linux and DB teams regarding various issues • Database restoration, health checks, operations and administration
1 Jahr, Jan. 2019 - Dez. 2019
Senior Database Administrator
Capita Pte Ltd
• Provide expert knowledge on the Administration to improve the application performance. • Taking care of issues in data migration and upgradations. • Performing Database upgradation and migrations as per the requirement. • Leading the projects as single resource for our clients. • Responsible for Project go live, Delivery and Smooth Ongoing operations. • Hands on experience in installation and configuration of Oracle 12c Middleware. • Taking care of issues residing on application side or DB side.
Sprachen
Englisch
Fließend