Database Administrator Sql Server

Shehroze Yousuf

Phone: 949-***-****

********.******@*****.*** https://www.linkedin.com/in/shehrozeyousuf/

A highly motivated, professional, with 12 plus years of diverse experience, currently serving as Senior DBA and delivering round-the-clock support. Proficient in troubleshooting, fine-tuning, and maintaining highly available IT infrastructures across various platforms. Possesses extensive expertise in MS SQL Server High Availability (FCI), including Always on Availability Groups, mirroring, replication and TDE encryption. Skilled in PostgreSQL and Oracle Databases (from version 9i to 19c), encompassing ASM and Grid infrastructure, cloud control and golden gate replication. Well-versed in Oracle VM, Flashback Technologies, RMAN Backup & recovery, RMAN cloning, and Cross-platform Transportable Tablespace (TTS). Demonstrates hands-on experience in Installation, upgradation, configuration, Administration, cloning, patching, migration, support, maintenance, monitoring, tuning and Capacity planning.

•Oracle database 9i to 19c DBaaS Cloud.

•Microsoft SQL Server FCI, Always on (AG), Mirroring, Replication and Log shipping

•Microsoft Azure SQL database, Elastic Pool and Managed Instance

•Postgres Stream replication.

•Postgres Clustering PGPool/Patroni, Backup and Recovery Manager (BARMAN)

•PGADMIN4, ORA2PG

•Advance Security including (Audit vault, Database vault, Data masking, Transparent Data Encryption).

•Oracle Real Application Cluster (RAC) 10g till 19c solution

•Oracle Data guard

•Golden Gate Replication

•Oracle Performance & Tuning

Microsoft Certified: Azure Database Administrator Associate. Certified

Oracle Autonomous Database Cloud 2019 Certified Specialist. Certified

Oracle Cloud Infrastructure 2019 Certified Architect Professional. Certified

Oracle Real Application Clusters 12c Certified Implementation Specialist. Certified

Oracle Linux 6 Certified Implementation Specialist. Certified

Oracle Database 11g Security Certified Implementation Specialist. Certified

Oracle Database 12c Administrator Certified Professional. Certified

Oracle Database 11g Performance Tuning Certified Expert. Certified

Oracle Database 11g Administrator Certified Professional. Certified

Oracle Database 11g Administrator Certified Associate. Certified

Postgres Database Administration. Trained

Oracle Exadata database machine administration. Trained

Master of Science, Information Technology (MS-IT): From Pimsat University

Bachelor of Commerce: from Karachi University

CLOUDMANIA IT Solutions (July 2020 till Date)

Senior Database Administrator

Key responsibilities:

Designed, Implemented SQL Server high availability solutions, achieving a downtime reduction of 80%

Configured Advance security feature including Transparent Data Encryption, Resulting in securing data at rest.

Configured Oracle snapshot standby database solution resulting in elimination of the need for setting up a new environment for UAT each time, saving approximately 40% of effort and resources.

Creating Database architecture based on client requirements and industry best practices.

Installing, configuring, and maintain database management systems (RDBMS)

Implement/automate regular backups and implement disaster recovery solutions.

Improved query performance by optimizing database queries, resulting in an average of 30 to 50% faster query execution.

Implemented security measures to safeguard sensitive data by implementing data redaction, reducing the risk of data exposure by 90%.

Ensuring compliance with data protection regulations and industry standards.

Keeping database up to date with the latest patches and updates.

Planning and executing data migration projects.

Providing technical support for database related issues.

Making recommendations for improvements based on database health check insights.

Virtual Remittance Gateway (Pvt) Ltd (May 2017 till July 2020)

Manager Database

Key responsibilities:

•Designed, deployed, maintained, administered, backed up/restored, and secured the complete database infrastructure of the company using Oracle, MS SQL Server and PostgreSQL as primary platforms. Ensured optimized performance, achieved the best possible Recovery Time Objective (RTO) & Recovery Point Objective (RPO), and managed integrated SLA across functions and systems.

•Implemented Postgres streaming replication for disaster recovery purposes and deployed BARMAN as a backup and recovery solution.

•Implemented PGPool Load balancing on PostgreSQL database, decreasing read operations on the production database by 35%.

•Controlled database access by configuring appropriate roles and managing Access Control Lists (ACL).

•Strengthened database security protocols, reducing the risk of security breaches by 30%

•Installed and configured new versions of the Oracle Relational Database Management System (RDBMS) and associated tools, as well as other tools accessing the Oracle database.

•Designed and implemented 12c Real Application Clusters (RAC) and Active Data Guard solutions to enhance database availability and disaster recovery capabilities, reducing downtime by 80%.

•Adhered to all Business Continuity Planning (BCP) & Disaster Recovery Planning (DRP) roles, including supporting IT Service Management (ITSM) services, providing Root Cause Analysis (RCA) support to the Database as a Service (DAS) team, and driving end-to-end system recovery and effective maintenance of Recovery Time Objectives (RTO).

•Engaged with associated product vendors to procure support services and effectively managed inward and outward Service Level Agreements (SLAs).

Oratech Systems (Pvt) Ltd (February 2015 till May 2017)

Senior Oracle Consultant

Key responsibilities:

Providing expert technical solutions and guidance to Clients and team DBA’s on adopting best Oracle practices and standards to enable the IT objectives.

Direct the Backup and Recovery strategy of the clients to ensure that disaster recovery, business continuity and protection of critical data service level agreements are both met as well as improved.

Provide Performance Tuning guidelines and direct the team in constantly optimizing response times for both batch processes as well as online transactional systems.

Prepare the roadmap and implementation plan for the migration and upgrade of applications currently on Windows and Oracle 10g to Oracle 11g on AIX and Linux platforms. Advice the best practices of data migration using enhanced techniques available like 11g Cross Platform Transportable Tablespaces and Data Pump.

Provide technical assistance and guidance to the team in implementing High Availability solutions for the group using features like Real Application Clusters, Flashback, Oracle Streams and 10g/11g/12c Data Guard with Automatic Failover.

Act as the Senior Oracle Applications DBA providing guidance and mentoring junior DBA’s in matters like tuning Oracle databases using AWR,ADDM Reports, Concurrent Managers and enhancing and optimizing the cloning as well as patching of the various different group 11i & r12 EBS environments.

KASB Securities (Pvt) Ltd (September 2012 till February 2015)

Assistant Manager Database

Key responsibilities:

Support ten plus databases including Oracle 10g, 11g and Microsoft SQL Server 2008 and 2012, play a lead role in enterprise-wide database optimization, instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries. Work actively on new 10g, 11g and R12 features such as AWR, ADDM, and ASH, ADADMIN / ADPATCH Utility, performance statistics collection, and fine tuning database wait events etc.

•Performs ongoing tuning of the database instances.

•Created and maintained databases on Microsoft SQL Server from version 2008 till 2012.

•Configured SQL Server Mirroring.

•Assists with impact analysis of any changes made to the database objects.

•Manage daily database backups and monitor backup of both Oracle and SQL Server databases.

•Communicate with Oracle Corporation for technical support

•Installation new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.

•Administers all database objects, including tables, clusters, indexes, Views, sequences, packages and procedures.

•Oracle Apps 11i and R12 Installation, Patching, Patch analysis, Cloning, Maintenance, etc.

Oratech Systems (Pvt) Ltd (February 2012 till September 2012)

Oracle Support Analyst (Deployed at British Petroleum as Resident Engineer)

Key responsibilities:

Configured Enterprise Manager

10g/11g Data guard with RMAN

Data pump/import & Export

Users Profiles, Sys Auditing

Installation, database patching & Administration

Maintained 5 Production Database instances.

Manage performance review of organization wide databases.

Perform database cloning, and data transfer for development environment using RMAN and Data pump.

Manage daily database backups and monitor backup logs for assurance.

Karachi Stock Exchange (Pvt) Ltd (October 2011 till February 2012)

Trainee Oracle DBA

Key responsibilities:

•Configure and troubleshoot workstation Database access setup.

•Help create documentation of every aspect of Database Management Systems including hardware configuration and maintenance records

•Installed database software on test environments when required.

•Help monitor newly installed databases for optimal performance.

•Help test newly installed databases in conjunction with application software.

•Other tasks as assigned by the manager

Projects accomplished with Oratech Systems Pvt LTD:

National Bank of Pakistan:

•Migrated database from 10g to 11g using Datapump.

•Tune Performance issues.

•Perform Switchover on 11g RAC Multi node database.

•Configured 11.2.0.4 database on AIX power Machines.

•Configured 11g active data guard on AIX Power Machine.

Dubai Islamic Bank:

•Implemented RAC 11gr2 11.2.0.3 on AIX.

•Configured two nodes RAC active Data Guard on 11.2.0.3 Database on AIX.

•Perform Switchover on 11g RAC Multi node database.

•Configured Snapshot Standby on 11gr2 RAC database.

•Tune up Performance Related Issues.

State Bank of Pakistan:

•Upgrade Java version on EBS 11i.

•Applied java patches on Oracle Applications 11.5.10.2 using adpatch utility.

Habib Bank Limited:

Configured Data Masking for POC Using 13c Enterprise Manager Cloud control.

NIB Bank:

•Perform switchover on 11gr2 single instance.

•Tuned database performance related issues.

Colgate Palmolive:

•Installed Oracle Database Software 12.1.0.2.

•Installed Linux Operating System 6.5.

•Upgraded Database from version 11.2.0.4 to 12.1.0.2 on Linux Platform.

•Prepared Active Data Guard on 12c Database.

Atlas Asset Management:

•Performed Switch over on 10.2.0.4 database for BCP.

Banking Mohtasib:

•Installed Oracle Database 11.2.0.4 on Linux 6.5.

•Migrated database from 9i to 11g.

Karachi Stock Exchange Limited:

•Configured Auditing on EBS R12 database.

Adamjee Life Insurance:

•Upgraded Java version on WebLogic server 10.3.6 version.

•Configured Data guard on version 11.2.0.3 on Linux 5.6.

•Perform switchover on 11gr2 single instance.

•Upgraded Oracle databases from 11.2.0.3 to 11.2.0.4 on OEL Linux 5.6

British Petroleum:

•Resident Engineer from Oratech System (Pvt) Ltd

•Performed Regular DBA routine tasks.

Contact this candidate