Senior Database Engineer @ Walmart Global eCommerce
Sr. Oracle DBA @ Optimum IT Solutions Inc.
Certified Oracle DBA with over 12 years of professional hands on experience performing installations, upgrades, maintenance, configuration, performance tuning, patching, backup and recovery of Oracle Databases in Multi-Tier configuration on different platforms (Solaris, HP UX, Linux and Windows). Good understanding with RAC, GoldenGate, ASM and DataGuard. In addition, very handy as aMicrosoft SQL Server and Oracle Apps
Certified Oracle DBA with over 12 years of professional hands on experience performing installations, upgrades, maintenance, configuration, performance tuning, patching, backup and recovery of Oracle Databases in Multi-Tier configuration on different platforms (Solaris, HP UX, Linux and Windows). Good understanding with RAC, GoldenGate, ASM and DataGuard. In addition, very handy as aMicrosoft SQL Server and Oracle Apps DBA with proficiency in Installing, Upgrading, Patching, implementation and Support.Highly proficient in performance analysis, tuning, application design and implementation of vendor software. A goal oriented, well disciplined, client focusedand team player with good leadership and inter personal communication skills.
Have worked with Oracle Applications Troubleshooting, Instance, Concurrent Manager Issues, Troubleshooting Long running Concurrent Requests, System Administration issues, Implementation in Shared APPL_TOP Implementation, Patching, Cloning, Maintenance.
A very good understanding with NoSQL Technologies like Cassandra and Neo4j on Core Concepts / Skills / Tools and Data Modeling.
Good analytical and leadership qualities. Capable to face and willing to accept new challenges in any environment.
Sr. Oracle DBA @ Optimum IT Solutions is an Oracle Gold partners that provides Database Management, remote DBA and Consulting services.
As a Senior Oracle DBA, I am responsible for design, development, implementation, production support and administration of database systems. Implemented and supported Oracle databases in a diverse and challenging environments. From January 2012 to Present (4 years) Greater New York City AreaSenior DBA @ Fifth & Pacific Companies Inc, formerly Liz Claiborne Inc. (Liz Claiborne) designs and markets a portfolio of retail-based, premium brands, including JUICY COUTURE, KATE SPADE and LUCKY BRAND. The Company also has a private brand jewelry design and development division, which markets brands through department stores and serves J.C. Penney Corporation.
• Managed tickets assigned or created in shift timings.
• Managing Backups, Refreshes from Prod, Dev, Test Environments.
• Creating SR with Oracle Support on any issue as and when needed.
• Managed/Monitored Junior team on any issue with Other Clients.
• Setup and maintain documentation as standards for future usage.
• Managing Installation, Configuration, Operations for Oracle Gateways for SQL 2005.
• Creating and Managing Shell scripts.
• Managed and Monitored Junior team members. From March 2011 to January 2012 (11 months) Senior DBA @ The end client is a large pharmaceutical in US, having more than 70 Databases ranging TB to GBs. Supporting night shift and clients and clients from INDIA/UK.
Creating custom scripts (KSH) as and when needed.
Periodically monitoring database live status of all databases.
Responsible for acting upon tickets created in shift timings.
Upgrading and Patching Oracle Databases as and when needed.
Configuring new databases with central RMAN and export for databases.
Creating SR with Oracle Support on any issue as and when needed.
Supporting/Monitoring Junior team in any issue with Local Clients.
Setup and maintain documentation as standards for future usage. From August 2009 to March 2011 (1 year 8 months) Senior Oracle Database Administrator @ Working as Sr DBA. My responsibilities are to Install/configure/Track/maintain database Other clients include HUBCO, 700 MW, AES Lalpir, 730 MW), HA Construction, Adamsoft International, Netsol Pvt Ltd.
Designed Backup/Recovery Strategies for clients.Recognize their OLTP/Storage/Hardware requirements and give expert recommendations. Responsible for the smooth functioning of databases of clients on support & in house development databases.
Have worked as a Senior DBA managing Installation, configuration, upgrade, patching, day to day operations.
Upgraded Oracle 8.1.5 to 8.1.7 as part of HRMS Application Project.
Upgraded Oracle 8.1.7 Database to 9.2.0 and applied Patches till 220.127.116.11.
Managed Server migration to new hardware.
Data Migration from Access 2.0 to Oracle 8.1.7.
Setup Oracle Snapshot replication.
Rebuilding of Indexes for better performance, maintenance of Oracle Database.
Configuring RMAN backups and export setup for databases.
Creating custom Shell scripts as and when needed.
Creating SR with Oracle Support on any issue as and when needed.
Managed/Monitored Junior team on any issue with Other Clients.
Setup and maintain documentation as standards for future usage.
Installation and configuration of Oracle 10g on RHEL 4.
Installation and configuration of Oracle 10g Forms and Reports Services.
Created the data model, table/index definitions (DDL), installation of Oracle software.
Installed and configured events/jobs with Oracle Enterprise Manager 8i/9i.
Worked as part of Engica and Main saver upgrade projects.
24x7 database production support. From March 2004 to August 2009 (5 years 6 months) Oracle Database Administrator @ Worked as an Oracle DBA and responsibilities included:
Installation and Configuration of Oracle (8i).
Database Backups and Recovery
I/O balancing by placing frequently accessed objects on different disks
Data model reviews and schema generations
Production implementation of Applications
Change management and implementation of Production systems’ enhancements
Used OEM- DBA Studio for maintaining database objects
Database Triggers, Stored Procedures etc. for the application development team.
Optimizing & Tuning slow running SQL statements.
Space Management - i.e. Tablespace creation, adding data files, creating rollback segments.
Backup scripts and ad-hoc backup of the databases From August 2001 to February 2004 (2 years 7 months)
MSc. in IT, Databases, Datawarehousing, OS and Networks and Project Management @ University of the Punjab, Lahore From 2006 to 2008 Aamer Javaid is skilled in: Oracle, Oracle RAC, RMAN, Oracle E-Business Suite, Oracle Enterprise Manager, Performance Tuning, Data Guard, Replication, Databases, Oracle SQL, Data Warehousing, Microsoft SQL Server, Unix, Solaris, Unix Shell Scripting
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension