SAIMA KALEEM ANSARI
Cell: 734-***-****
*** ********* **. *** ***** Village, IL - 60007
addfug@r.postjobfree.com
Professional Summary:
Management with 6 years of experience providing cradle-to-grave management over large-scale IT implementations. Total IT Experience more than 17 years. Excel at liaising between business and technical areas to achieve on-time and on-spec project completions. Able to merge customer and user needs with business requirements to meet project deliverables. Key skills:
Project Lifecycle Management
Enterprise wide Implementations
System Migrations
Requirements Definition & Analysis
Team Building & Leadership
Quality Assurance
Database Administration
Seamless Deployment of Project.
Custom Software Development
ERP Implementation
Database Design (RDBMS)
Client Relations & Presentations
Cross-Functional Supervision
Systems Engineering
System Migrations/Integrations
Requirements Analysis
Testing/QA/Rollout/Support
Change Management
Release Management.
Business & IT Planning
Oracle Cloud Infrastructure - OCI
Vendor Management
Work Status. US Citizen
AWARDS & HONORS
Technology Infrastructure Transformation 2013 – 2015 from Ally Financials
Service Excellence Award from IBM in 2008
Achieved Appreciation Certificate from French Air Total System for implementing their system successfully.
Management with Technical Skills:
Managing projects / Operations as technically (Prioritize, Plan, Incident Management, Problem Management, Change Management and Release Management).
Trusted contribution of the development of database standards and best practice for the organization.
Providing solution as per the business needs.
Suggestion for Automation and building strategies for the Database Team.
Involved in Infrastructure Management projects and managing resources.
Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.
Managing Releases for the databases and Applications. Accountable for the releases and manage the issues due to builds and deployments.
Working on ITIL standards.
Completed end to end project of ERP Implementation.
Lead database diverse team in architecture, engineering and operational support delivering business value through efficiencies, reduced delivery times, ensuring highly reliable, available, and scalable operations. Lead large to midsize databases.
Managing On boarding process and releasing resource process. Resource management with work load management.
Involved in Enterprise level technical discussions for securities and roles assignments.
Managing technical teams to ensure seamless deployments.
Manage the execution of all code deployments to Production and non-Production environments
A proven leader Database team with as many as professional dispersed around the globe.
Adapt in database architecture, Database documentation process and Database Applications.
Strong IT skills with an ability to learn new applications and skills quickly.
Define process to handle the resource request as well the availability of resources for PROD Issues.
Strong ability to multi-task and move between short- and long-term data requests/projects
Strong communications skills and building relationship with clients.
Collaboration with other architects, engineers and support staff on the design, development and rollout of tools that are secure, robust and maintainable.
Defined Change management process and handling, Sox controls (SOX/ PCI), IT Security for the End users and databases on Enterprise level.
Coaching, mentoring and creating a goals and objectives for the team.
A proven leader Database team with as many as professional dispersed around the globe.
Managing Development teams in the area of technical designs and development.
Trusted contribution of the development of database standards and best practice for the organization.
RDBMS Management & Administration and Architectural focus for cross functional teams.
OPERATING SYSTEMS:
Windows NT 4.0 server.
Enterprise Red Hat Linux.
AIX.
Linux
HPUX
SUSE Linux
Sun Solaris
DATABASES AND APPLICATIONS:
Oracle Database (8i/9i/10g/11g, 12c, 19c).
EBS 11i and R12.
Oracle Cloud Infrastructure - OCI
EXPERIENCE:
Tata Consulting Services – Walgreens Dec 2019 to present
Working as Sr. Oracle DBA / Lead Architect in Walgreens for pharmacy database architecture and management.
Provide Infrastructure solution during project requirement.
Perform engineering for creating POC environments and lead the practice.
Managing DBA Team and the DBA on Call rotations.
Managing databases and Upgrade projects.
Management of Patching in the project cycle for GI and RDBMS PSU / RUs April 2020.
Worked in ITIL standards for Release Management Change management process.
Leading Disaster recovery Activity and the operational activities.
Drove impressive improvements across the business as a result of IT implementations.
Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms.
Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.
Apex systems in Wells Fargo - Rosemont, IL Jul 2019 to Nov 2019
Sr. Oracle DBA / Architect:
Working as Sr. Oracle database Architect DBA in Wells Fargo Union in which providing Enterprise level Architectural and DBA support.
Provide Infrastructure solution during project requirement.
Managing DBAs.
Performing Release Management.
Performing database PSU and OJVM patching with complete series from DEV - UAT - PROD
Trusted contribution of the development of database standards and best practice for the compliance of databases.
Leading Database Upgrade from 11g to 12c from DEV to Critical Production databases.
Providing solution as per the business needs.
Performed Database character set Migration from US7ASCII to AL32UTF8
Performed Cloning DB and APPS Tier.
Physical Data guard configuration and maintenance.
Performed Physical Data Guard build and Snapshot builds and maintenance.
Attended in Discussion of making strategies for 2020.
Providing strategy how to upgrade of Java for Database and Apps Tier.
Routine Application, Database and architecture support to the business.
Ally Financial Inc. - Detroit, MI Dec 2014 to 7-Mar 2019
Database Admin Manager:
Oversaw all database functions including architecture, system and application database functions, security and compliance functions including but not limited to installation, configuration, upgrades, migration, availability, disaster recovery configuration, monitoring, backup, recovery, and performance tuning.
Managing projects / Operations as technically (Prioritize, Plan, Incident Management, Problem Management, Change Management and Release Management).
Oracle Cloud Infrastructure Management.
Drove impressive improvements across the business as a result of IT implementations.
Trusted contribution of the development of database standards and best practice for the organization.
Providing solution as per the business needs.
Managing On boarding process and releasing resource process.
Suggestion for Automation and building strategies for the Database Team.
Managing Releases for the databases and Applications.
Working on ITIL standards.
Leading Database upgrade projects.
Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.
Managing Decommissioning of databases and servers and resources.
Lead database diverse team in architecture, engineering and operational support delivering business value through efficiencies, reduced delivery times, ensuring highly reliable, available, and scalable operations. Lead large to midsize databases.
Involved in technical discussions for securities and roles assignments.
Making sure database and applications are in security compliance.
Managing technical teams to ensure seamless deployments.
Managing MS SQL Server team.
Accountable for the releases and manage the issues due to builds and deployments.
Manage the execution of all code deployments to Production and non-Production environments
A proven leader Database team with as many as professional dispersed around the globe.
Adapt in database architecture, Database documentation process and Database Applications.
Strong IT skills with an ability to learn new applications and skills quickly.
Define process to handle the resource request as well the availability of resources for PROD Issues.
Strong ability to multi-task and move between short- and long-term data requests/projects
Strong communications skills and building relationship with clients.
Collaboration with other architects, engineers and support staff on the design, development and rollout of tools that are secure, robust and maintainable.
Defined Change management process and handling, Sox controls (SOX/ PCI), IT Security for the End users and databases on Enterprise level.
Managing SQL/ Exadata / Oracle database teams.
Coaching, mentoring and creating a goals and objectives for the team.
Resource management with work load management.
A proven leader Database team with as many as professional dispersed around the globe.
Managing Development teams in the area of technical designs and development.
Trusted contribution of the development of database standards and best practice for the organization.
Coaching, mentoring and creating a goals and objectives for the team.
RDBMS Management & Administration and Architectural focus for cross functional teams.
Kforce Flexible Solutions INC - Detroit, MI Nov 2013 to Dec 2014
Database Admin Manager:
Oversaw all database functions including architecture, system and application database functions, security and compliance functions including but not limited to installation, configuration, upgrades, migration, availability, disaster recovery configuration, monitoring, backup, recovery, and performance tuning.
Strong IT skills with an ability to learn new applications and skills quickly
Managing Releases for the deployments.
Change Management and status given to the all stakeholders.
Making sure database and applications are in security compliance.
Lead Database Administering various multi-Terabyte, 24x7 uptime Oracle databases.
Strong experience working with Oracle versions 10g, 11g,12C in a UNIX / AIX environment
Strong experience with features such as RAC, ASM, Active Data Guard, Oracle Enterprise Manager (OEM), and Data Pump.
Participate in Follow-The-Sun 24x7 support environment accustomed to be on-call rotation
Experience with Golden Gate.
Collaboration with other architects, engineers and support staff on the design, development and rollout of tools that are secure, robust and maintainable.
Defined Change management process and handling, Sox controls, IT Security for the End users and databases on Enterprise level.
Credit Acceptance - Southfield, MI Oct 2012 to Jul 2013
Sr. Oracle DBA / Lead:
Working as a Sr. Oracle Apps DBA Lead to complete the Upgrade Oracle ERP Project in Credit Acceptance, which gives technical support to upgrade project and other providing enterprise solutions.
On site and remotely handing EBS 11i and R12 upgrade
Managing offshore teams & Technical Team handling with their tasks and issues.
Installation of RAC with EBS R12.
Managing Releases for the deployments.
Change Management and status given to the all stakeholders.
Making sure database and applications are in security compliance.
Handling Production Development and QA Oracle Databases.
Perform backup and recovery, performance and tuning, creating Dev, QA, Testing environment.
Prepare Internal and External Middle Tiers with DMZ IRecruitement and SSL Configuration.
Cloning, Patching & Routine DBA Tasks performed.
Routine DBA Activities. Handling Junior DBA's Tasks and their activities.
Service Request Creation and handling.
Tickets handling and time card management and change management as per the business requirements.
Provided Support as an SME.
Remote DBA Experts (Pittsburgh) - Remote Jul 2012 to Aug 2012
Sr. Oracle Apps DBA
Working as a Sr. Oracle Apps DBA in Remote DBA Experts, which gives technical support & consultancy to the different clients and giving enterprise solutions.
Remotely handing databases with Oracle 11g Production, Test, Development, Patch instances.
Performed OATM Upgrade from 11i to R12.
Cloning, Patching & Routine DBA Tasks performed.
Giving on call support.
Tickets handling and time card management.
I3Packages Apr 2010 to May 2011
Sr. Oracle Database Administrator - KHI, Pakistan
Working as a Sr. Oracle DBA in I3Packages which gives technical architectural solutions & availability to the financial institution and enterprises for ORACLE ERP and Giving Support to Oracle Databases.
International Business Machines (IBM) - KHI, Pakistan Dec 2007 to Feb 2010
Sr. Oracle Database Lead:
Working as Sr. Oracle Database Lead Consultant in IBM (Global Business Services Department (GBS)) on ORACLE / SAP both that provides solutions to mid and fortune 1000 businesses end to end.
MCB Bank - KHI, Pakistan Mar 2007 to Nov 2007
Sr. Database Administrator – Data Warehouse system –
Manage & responsible for Oracle Data warehouse from knowledge manager of Symbols of Sun Products for core banking system.
K.K Pharma Pvt. Limited - KHI, Pakistan Oct 2005 to Mar 2007
Database Administrator - Distributed System
Providing support to the Distributed Database system.
PSO (Oil & GAS Company) - KHI, Pakistan Aug 2002 to Sep 2005
Oracle Database Administrator
Developed Sales & Distributing System which runs on distributed environments in all Depot & Installations and handling data reconciliation through Oracle Replication. Involved in SAP Installation as a Technical Lead in BASIS.
EDUCATION & CERTIFICATIONS
Bachelor of Commerce
Emphasis: Accounting
Karachi, Pakistan
Oracle Certified Professional DBA Track (10g)
Courses:
Attended Course of Oracle Cloud Infrastructure Solution Architect – OCI - 1Z0-1072
Attending Course of MS Azure Cloud Solution Architect – MS Azure – AZ-103 / 104
Attended Overview Course of BASIS (i.e. SAP50)
Attended Training Course of HPUX
Attended Training Course of SUSE Linux
Certificate Course of Application Server 10G (Admin I & II) from Oracle Corporation.
Certificate Course of Oracle Database 10g Administration Workshop II from Oracle Corporation.
Certificate Course of 11i Install, Patch and Maintain Oracle Applications.
Introduction to Project Management &PMP Certification Course from BMC.
PM Roles & Responsibly in GBS and Delivery Excellence.
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Ed 3. From Oracle University Chicago.
Postgres plus Advance Server9.4 Associate Certification.
AVAILABILITY: 2 weeks of time after issuing Offer letter.