Database Manager
ISlamabad Diagnostic Center IDC
Total years of experience :16 years, 4 Months
-Installation, Administration and Maintenance of ORACLE and SQL Server Database.
-Setup Test, Dev., Staging and Production Environments.
-Create Users and assign permissions based on the level of database access the user would need.
-Design database Backup and Restoration Strategy.
-Once created the database Backups, monitor those backups are being performed regularly.
-From time to time recover the databases to a specific point of time, as per the requests.
-Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering,
Database Mirroring, Log Shipping and Replication)
-Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server
Error Logs and checking your email alert (if there is one configured))
-Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)
-Documenting major changes to the SQL Servers.
-Apply Service Packs.
-Database tuning performance using DMV’s and nodes and server resources monitoring through DMV’s.
• Daily Reporting through T-Sql.
• Database Tuning and Maintenance through SQL & Oracle
o Backup and recovery of entire database.
• Taking daily back on system and tape device.
• Restoring the crashed or corrupt databases from backup files.
o Replicating the Database to and from had office servers using Merge Replication.
o Generating the snapshots on Need.
• Monitoring the Database Performance MS SQL & Oracle
• Database Development and transactions through MS SQL
o Using DDL and DML commands.
o Creating and modifying the stored procedures.
o Creating and modifying triggers
o Creating and monitoring the jobs for different tasks.
• Working with different teams of the Organization.
o Analyzing and normalizing the databases.
o Creating and altering the databases and Reports for desktop and web applications.
o Creating and altering the tables using T-Sql and GUI.
• Reporting Server MS SQL SERVER SSIS, SSRS
o Configuring the Reporting server of Sql Server and ETL Development.
o Monitoring creating the reports for Operation deportment and Other Deportment's for daily, weekly and monthly Reports.
• Help in development of complex ad hoc queries and analyses. Works in conjunction with data analysts for developing dashboards and other end user solutions. Works with business analysts and acts as a liaison between technical departments and business departments. Trains the power users of respective businesses along with business analysis.
-Installation, Administration and Maintenance of SQL Server Instances.
-Setup Test, Dev., Staging and Production Environments.
-Create Users and assign permissions based on the level of database access the user would need.
-Create Linked Servers to SQL Servers and other databases such as Oracle etc.
-Design database Backup and Restoration Strategy.
-Once created the database Backups, monitor those backups are being performed regularly.
-From time to time recover the databases to a specific point of time, as per the requests.
-Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering,
Database Mirroring, Log Shipping and Replication)
-Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server
Error Logs and checking your email alert (if there is one configured))
-Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)
-Documenting major changes to the SQL Servers.
-Apply Service Packs.
-Database tuning performance using DMV’s and nodes and server resources monitoring through DMV’s.
Worked to manage Oracle 11gR2 Database, RAC, Oracle people Soft ERP, MS SQL 2008 Database Administration.
worked with Emaar properties technologies as Sr.MS SQL DBA on 3 month outsource from esquire systems till 9th October 2012.
Working as SQL SERVER and ORACLE 10g DBA, replication, maintenance, recovery, SSIS, SSRS and on SSAS.
Worked as Database Developer working with software development team database maintenance and recovery.
Worked as SQL SERVER Database Administrator, database tuning maintenance and reporting database development and data analysis.
MS SQL SERVER 2012 Database Administration.
Oracle 10g DBA certification. OCP 10g
Masters Degree in Information technology, Software engineering and Databases
Double Maths , Computer science
3 years Diploma of associate civil engineer
Matriculation