Resume

Sign in

Sql Server Manager

Location:
Newmarket, Ontario, Canada
Posted:
August 30, 2017

Contact this candidate

PROFESSIONAL SUMMARY

Database administrator (DBA) with 10 years of experience in IT and 7+ years of experience in advanced DBA skills with significant management experience of Datacenter infrastructure.

MAJOR SKILLS AND ABILITIES

Core DBA (SQL Server/Oracle) (7 Years)

RAC & ASM (6 Years)

Performance Tuning (SQL Server/Oracle) (4 Years)

Data Guard (5 Years)

Patching & Upgrading (7 Years)

Golden Gate (5 Years)

Red Hat Linux/Sun Solaris/Windows (10 Years)

Shell Scripting (5 Years)

Backup & Recovery (SQL Server/Oracle) (7 Years)

Fog Light (2 years)

KEY PROJECTS

Successful multiple migrations of databases with size up to 1.5 TB to new servers with nearly zero down time to minimum time period in different platforms (Linux/Unix/Windows)

Successful multiple upgrades from SQL server 2005, 2008, 2012 by using methods like in place upgrade and out of place upgrade

Created Linked Servers between SQL server 2008/2012 and Oracle servers in the environment

To eliminate in performance bottleneck at the registration time (People Soft Campus Solutions), converted single instance database to 3 node cluster on Oracle Linux based machines and different performance tuning tasks

Implemented AlwaysON for disaster recovery and sharing data from associated colleges to main university campus and to prevent single point of failure

Vendor Certification: Oracle Certified Profession, OCP 11g database administration; Oracle Certified Expert, OCE in Oracle Real Application Cluster (RAC) and Grid Infrastructure administration

Moved the whole RAC cluster to new Servers with zero down time in Oracle environment

Coordinated, Managed and participated in projects like hardware infrastructure and licensing involving multiple vendors (e.g. Oracle, IBM, Huawei, Dell) and stakeholders

Completed Project from Minister of Education for Data sharing for student information system and HR system from the University and affiliated colleges

Worked as lead to develop the new data center for university and affiliated colleges which includes capacity planning, hardware sizing and infrastructure planning for data center

Proven track record of working on Linux/Unix/Windows and supporting MS SQL Server Databases

Masters in distributed database management system

WORK EXPERIENCE

SQL Server DB Administrator University of Hafar Al Batin(KSA) 2014-2017

Responsible for infrastructure design, maintenance, upgrades and administration of redundant data-centers to ensure high-availability, automated fail-over, data consolidation, distributed-availability and load balanced environment

Experience in Installing, upgrading and configuring Microsoft SQL Server 2005/ 2008 & 2012 instances and its various components like Integration Services(SSIS), Reporting Services(SSRS), Client and Connectivity Tools and Analysis Services etc

Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done

Experience in safeguarding data by installing backup, managing user access and securing databases.

Good knowledge on managing SQL Logins, DB users, Roles and Authentication Modes, SQL Service packs & Hot fixes as a part of Security Policies for various categories

Experience in planning, organizing, directing, controlling and monitoring the database operations to support mission critical database servers

Involvement in decision making about infrastructure enhancement, storage media, capacity planning and relevant costing/budgeting

Responsible to perform the performance tuning/optimization of enterprise database servers

Prepare and implement data requirements, data collection, data access, data usage policies in accordance with the Information security & compliance standards

Experience in providing 24x7 support and assistance to development and testing teams

Working in SQL Server 2005, 2008 and 2012 to ensure high availability of database systems and recovery from disasters by employing the following methods: failover clustering, mirroring, log shipping and replication

Experience in using scripts or writing code in T-SQL and SQL to automate processes

Application and database performance tuning using tools provided by Microsoft such as Performance Monitor (perfmon) and Profiler / SQL Server Trace and database tuning advisor

Using the Enterprise tools like FogLight for monitoring the instances resources, performance

Oracle RAC & Database Administrator University of Hafar Al Batin(KSA) 2010-2017

7+ years of experience as DBA of supporting multiple databases in production, development and test environments from small scale to large scale up to 1.5 TB

7+ experience of providing remote and on-site support for middle tier application and database tier for University and associated colleges

5+ years of experiencing of administering the advanced Database software technologies for high availability and disaster recovery on different hardware and OS platforms like Linux/Unix/Windows

Performance tuning at hardware level, database level and OS level of OLTP databases

Preparation Linux /Unix Servers from scratch and implemented the standard procedures of oracle databases, Grid Infrastructure, and application programs for SIS/ERP multiple times

5.5+ years of experience in Oracle Enterprise Manager, Oracle Grid Control 11g and Cloud Control 12c, and database diagnostic tools (ADR, AWR etc.)

Identified Top SQL and A Identified performance bottlenecks in H/W, Storage, Network, OS & Database Level including database query tuning by end to end analysis of the RDBMS platform

Implementation and optimization of backup policy, developed Oracle backup and recovery scripts to implement automated backup and disaster recovery by using shell scripts and Enterprise Manager

5+ years of experience of Upgrades and patches (PSU & CPU) that includes in place upgrades, out of place upgrades from 10g,11g (release 1 and release 2), 12C using different methods like manual, DBUA and golden Gate to ensure nearly zero down time of the databases for SIS and ERP databases

Data Support Manager SWAT Security (UK) 2006 -2009

Developed and maintained (as a team member) the information system for the company, which provides security solution in Oracle and Visual Basic

Maintained the records of the company contracts from other companies, with tax information and payroll information management of employees and developed reports

CERTIFICATIONS AND TRAININGS

Certification: Oracle Certified Expert (OCE) 11g RAC and Grid Infrastructure administrator

Training: by Infinite Skills: Linux System Administration

Certification: Oracle Certified Professional (OCP) 11g Database Administrator

Training: by Orasol, Administrating Real Application Clusters and ASM devices

Training: by Orasol, Oracle Data Guard 11g & Oracle Golden Gate 12c

Certification: Oracle Certified Associate (OCA) 11g Database Administrator

Training: by Oracle University: Database backup and recovery

Training: by Oracle ERP Training, Oracle Apps module of Human Capital Management (HCM)

Training: by Orasol, Oracle Apps Administrator(ERP)

EDUCATION

Masters Distributed Database Management Systems 2006 -2009

(WES: Equivalent to Canadian Master’s degree)

Liverpool John Moores University, Liverpool, England

Post Graduate Diploma E Commerce 2004- 2005

Oxford College of Management Studies. London, England.

Bachelors Computer Science 2001-2004

(WES: Equivalent to Canadian Bachelor degree)

Allama Iqbal University, Islamabad, Pakistan



Contact this candidate