A Microsoft Certified SQL Server Database Administrator (DBA) with over five years
Of progressive professional working experience in all aspects of SQL Server
Databases (2000, 2005, 2008, 2008r2 and 2012), including installation,
configurations, and database high availability solutions (mirroring, log shipping,
replication and failover cluster). Proven ability in managing large databases in a
24/7 processing environment including backup/recovery, performance tuning,
developing and managing reports using SQL Reporting Services (SSRS), creating
SSIS packages, Monitoring Performance Tuning, stored procedures, triggers,
functions, constraints and views etc. Prior experience database third party tools ERWin and Toad Data Modeler. Strong knowledge of database backup, disaster recovery, and point-in-time recovery through backup database
restoration. Proficient in using DBCC to check database conditions, rebuilding
indexes and to perform other database maintenance functions. Additional
proficiency in creating and modifying tables, indexes (Cluster/Non-Cluster),
constraints (Unique/Check),and views, as well as developing maintenance plans
for monitoring and server activity, and resolving troubleshooting questions as
Experience in production, test, development environments and proficiency of the following:
-Installation, configuration & maintenance of MS SQL Server 2000, 2005, 2008 and 2012 on standalone and clustered servers [both active/active and active/passive cluster design].
-Applied SP (Service Packs) and hot fixes.
-Upgrades of SQL Server 2000, 2005, 2008 and 2012.
-Configuration tools such as SQL Server Configuration Manager and SQL Server Surface Area Configuration.
-Data Modeling tools (Data Modeler and Toad).
-Forward and backward engineering.
-Database backup, recovery and disaster recovery procedures.
-Database High Availability Solutions.
-Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers.
-Database Monitoring and Performance Tuning.
-Database consistency checks using DBCC commands.
-SQL Server Reporting Services [SSRS].
-Creating and scheduling SSIS/DTS packages in SQL Server to transfer data between various DBMS and files.
-Ability to debug SQL Server stored procedures and triggers.
-Ability to create and perform alerts, schema management, database reorganization, data loading,
database maintenance and optimization.
Installs, Configures, and Manages SQL Server 2005 & 2000 in development, test, and production environments and installs and configures SQL Server 2008 for testing different features and stability backup/recovery. Performs database backup and disaster recovery using point-in-time restoration.
Performs database high availability and installs, configures and maintains database mirroring including automatic fail-over option in SQL Server 2008. Configures log shipping as standby database from production database for reporting purposes. Performs clustering
using SQL Server 2008/2005. Configures and maintains Replication.
Uses DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance functions.
Development: Installs, Configures, and administers SQL Server Reporting Services (SSRS). Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 as well as deploying reports and managing security of report server.
Exporting& importing data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS. Exporting& importing data from/to databases like Oracle, My-SQL, and Access to/from SQL. Performing server database upgrades, like SQL Server 2000 to 2005/2008/2008 R2 SQL Server 2005 to SQL Server 2008/2008 R2. Performs database migration, like MS Access 97/2000/2003 databases into MS SQL Server 2000, 2005, and 2008, Oracle databases to SQL Server 2008 R2, My-SQL databases to SQL Server 2005/2008 R2.
Conducts data modeling through conceptual, logical, and physical data models. Works on data modeling projects from start to finish, and includes generating scripts for objects, developing relationships between tables, and creating E-R diagrams. Performs backward & forward engineering for logical and physical data models respectively.
Utilization of tools such as Erwin and SSD. Creation and management of objects, schemas, indexes, and constraints.
Application of SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2 and application of patch on Windows Server 2003, 2003 R2.
Conducts database monitoring/performance tuning/scheduled jobs to automate different activities such as: monitoring database health, disk space, job, alert, index monitoring, etc.
Assists database developers to optimize SQL queries, stored procedures, T-SQL and Triggers. Work environment includes: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5. SQL Server 2008 R2, 2005. ASP.net, PHP, AD (Active Directory)
Installed, Configured, and Managed SQL Server 2008, 2005 & 2000 in development, test, and production environment.
Installed and Configured SQL Server 2008 for testing different features and stability.
Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery experienced with Point-in-Time Recovery. Restored Database from backup
Database High Availability: Installed, Configured and Maintained Database Mirroring including automatic fail-over option
in SQL Server 2008. Configured Log Shipping as Standby database from Production database for reporting purposes. Maintained Fail-Over Clustering using SQL Server 2008/2005. Configured and Maintained Replications
Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well Report Development.
Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0.
Deployed Reports and managed security of report server including folder level.
SQL Server 2000 to 2005/2008/2008 R2.
SQL Server 2005 to SQL Server 2008/2008 R2.
MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008.
Oracle 10gR2/11gR2 databases to SQL Server 2008 R2.
My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2.
Worked on data modeling projects, generated scripts, and E-R Diagram
Backward & Forward Engineering for logical and physical model respectively Data Modeling tools used using ERWin, Toad Data Modeler
Created and managed Indexes, Constraints.
Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2
Applied Patch on Windows Server 2003, 2003 R2
Active Directory, Automation, Backup, Clustering, Hardware, Data Modeling, DTS, Database Administration, Disaster Recovery,IIS, IIS 7.5, Access, MS Access, MS Access 2000, Microsoft Office, Windows Operating Systems, 2000, 2003, 2008, 2008r2, 2012, Windows (XP, Vista, 7 and 8) Migration, Optimization.
TSQL, RAID, SAN, Upgrade, Web Applications, Web Server
Companies Worked For:
Job Titles Held: