Sql Server Data

Career Objective:

Seeking career with goal to become a Chief Data Architect position in a

growth oriented progressive organization.

Areas of Expertise:

. 7+ years of hands-on experience with SQL Server 2008R2, 2008, 2005,

2000 & 2 years with SQL 2012 Database Administration and Microsoft

Business Intelligence Development in Production, Staging and

Development Environments.

. Experience with Installation and Configuration of MS SQL Server

2012/2008R2/2005/2000.

. Experience with Database Backup (Full/Differential/Transaction Log),

Recovery and Disaster Recovery Procedures.

. Experience with the high availability SQL Server

solutions including Database Mirroring, Log shipping and Replication.

. Experience in implementing different types of Replication Models such

as Transactional, Snapshot and Merge in SQL Server

2012/2008R2/2008/2005 in OLTP environments.

. Experience in Database Migration. Migrated SQL Server 2005 to SQL

2008, SQL Server 2008 to 2008R2, SQL Server 2008R2 to 2012.

. Migrated data from one server to another using Data Transformation

Services (DTS) tools and SQL Server Integration Services.

. Experience in maintaining SQL Server Clustering and resolving issues

in it. Worked on Active-Active and Active-Passive Clustering.

. Very Good Experience in BI Development (SSRS, SSIS, SSAS). Created

Dynamic charts and reports using SQL Server SSRS.

. Expertise in creating SSIS packages, SSAS, OLAP, ROLAP, MOLAP cubes

creation and writing MDX queries.

. Experience designing Star Schema and Snow Flake Schema. Experience in

Cube partitioning for optimal performance.

. Expertise in writing and debugging Stored Procedures, Functions

& Triggers. Expertise in data normalization and de-normalization

. Investigating and applying necessary SQL Server database patches,

installing service packs and upgrading to higher versions.

. Experience with Database Performance Tuning, Query

Optimization, Client / Server Connectivity / Network Issues, Named

Pipes, TCP/IP Protocols, Database consistency checks using DBCC

Utilities, Troubleshooting.

. Experience in scheduling SQL Server Jobs, Maintenance plans and

automating administrative tasks.

. Implementing security at server, database and object level. Experience

with AlwaysOn availability groups.

. Experience with SQL Server Indexing. Analyzing and fixing index

fragmentation in SQL Server 2012.

. Experience in designing SSAS 2012 Cubes and building attribute

relationships for optimal MDX query performance of Hierarchies.

Certifications:

. Microsoft Certified Solutions Expert (MCSE): Business Intelligence,

Microsoft, and License: E720-3294.

. Microsoft Certified Solutions Associate (MCSA): SQL Server 2012,

Microsoft, License: E405-1609.

. Microsoft Certified Professional, Microsoft, License: E386-1834.

. ISO 8000-110:2009 Data Quality Standard for Master Data awarded by

Institute for Certification and Training of Information Professionals

(ICTIP).

. Diploma in Basic Electronics and Hardware Engineering(no. 5094/07) at

Soft Traks Institute of Information Technology recognized by Govt. of

AP, India(Regd. no. 00419).

. Diploma in Computer Applications (no. 5094/07) at Soft Traks Institute

of Information Technology regd. by Govt. of AP, India.

. Oracle Database 11g Administrator Certified Associate, License:

OC1329211.

. Oracle Database SQL Certified Expert, License: OC1329211.

Technical Skills:

Languages: T-SQL, ASP.NET, SQL, PL/SQL, MDX/DMX, Java.

Databases: MS SQL Server 2012/2008R2/2008/2005, MySQL, Oracle 11g.

Development Tools: Rational Rose, DataFlux, Data Cleaner, BIDS, Weka, Net

Beans.

Database Tools: SQL Profiler, Query Analyzer, Index Analyzer, SQL Agents,

SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Backup

and Restore, Replication, Log Shipping.

Microsoft Tools: Visual Studio, SSIS, SSAS, SSRS, SSMS, Visio, Office 2010.

Architecture: Relational DBMS, Client-Server Architecture, OLTP, OLAP.

Operating Systems: Windows Server 2008R2/2008/2003, Windows vista/7, Redhat

LINUX, UNIX.

Work Experience:

SQL Database Administrator, Arkansas Department of Information Systems,

May'13 - Till Date.

Responsibilities:

. Extensively worked on Database conversions from Informix to SQL Server

2008R2.

. Involved in supporting of MS SQL Server 2012, 2008 R2, 2005 and 2000

in Production, Testing, and Development Environments.

. Performed Backups (Full, Differential, Transaction log) and restores

on the conversion server; extensively used TSM litespeed backups.

Database Monitoring and Managing services.

. Involved in Capacity planning and upgrading of SQL Servers.

. Performed Backups from conversion server to production server and

restore to conversion server.

. Wrote and debugged T-SQL stored procedures and triggers. Involved

in performance tuning of queries for query efficiency

. Worked with DBA team to identify errors and fixing it during the Data

conversions and migrations. Resolved deadlock issues in the

application using SQL Profiler.

. Provided 24/7 On-Call support to Mission critical Environments and

expertise with Disaster Recovery mechanisms.

. Generated several dynamic drill down and drill through reports using

SQL Server SSRS.

. Designed and developed ETL processes using SSIS to receive customer

files from data warehouses and load them into transaction processing

systems.

. Resolved issues for mission critical high usage of system CPU, Disk,

Deadlocks and Transaction per/sec

. Worked on migration from SQL 2005 to SQL 2012/2008R2 including

databases, logins, users, jobs, DTS packages.

. Performed Database Refresh tasks from production to non production

Servers

. Used SQL Server Agent for scheduling jobs and alerts.

. Analyzed the performance counters and agent jobs execution times on

production and development servers; fixed problems causing slow

performance.

Database Administrator, University of Arkansas at Little Rock, Jul'12-

May'13.

Responsibilities:

. Installed and maintained SQL Server and Oracle database systems.

Monitored success and failure of automated jobs.

. Duties include Oracle database installation, Database creation,

monitoring, maintaining, performance tuning, backup &recovery,

Recovery Manager (RMAN), Database Cloning, Data Guard.

. Logical backup and recoveries using export/import. Physical backup

which includes cold and hot backup.

. Configured environmental variables (oracle_home/SID/Path), parameters

(bash_ profile, init.ora, pfile, spfile, alert log).

. Worked with Oracle listener and TNS name problems as a part of

networking; creating materialized views and DB links.

. Managed physical storage including data files, online redo log files,

control files, archived log files, initialization parameter files.

. Worked on Storage management, Tablespace management, User management,

redolog management etc.

. Updated databases by reviewing, planning, testing and installing

database security patches and service packs.

. Monitored and modified Performance using execution plans and Index

tuning.

. Updated student's data at UALR so that BANNER database holds the most

updated information to be submitted to the Arkansas Department of

Higher Education.

. Performance monitoring, tuning and SQL Server optimization using the

query execution plans, SQL Server profiler, Dynamic Management Views,

Activity monitor and system monitor.

. Performed Routine jobs like backup and restore using oracle utilities.

Performed Hot and Cold backups.

SQL Database Admin, Mahivar Inc., India, Mar'10-Jun'12.

Responsibilities:

. Integrated and transformed data from different sources like Oracle,

DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB

connection by creating various SSIS packages.

. Created ETL (SSIS) process to transfer the data from OLTP Files to

data warehouse, scheduled and monitored jobs.

. Developed SSAS Cubes, Data Mining Models, Deployed and Processed SSAS

objects, and wrote MDX queries to retrieve the data from the cubes and

perspectives.

. Created and deployed cubes in star and snowflake schema. Performed and

worked with dimensions, measures, generating KPI, MDX queries.

. Performed Database consistency checks with DBCC, Defrag, Index tuning

and monitored error logs.

. Database Performance of Index tuning using Database Engine Tuning

Advisor to resolve Performance issues

. Performed security tasks like Grant, Revoke permissions. Implemented

security at server, database and object level.

. Worked with BravePoint Pro2 replication suite during database

replication. Worked on Radley's X/DC development and integration

platform.

. Worked on a Healthcare project where the duties involved

Denormalization of the patient data using SSIS, Analyzing it using

SSAS and creating interactive reports using SSRS. Maintained and

managed critical Databases.

. 24x7 on call support in case of a production environment.

. Created parameterized Reports using Charts, Cross-Tab and Sub-report

types. Generated matrix reports, drill down, and drill through dynamic

reports using SQL Server Reporting Services.

Database Developer/Administrator, DCET, Osmania University, Mar'07-Feb'10.

Responsibilities:

. Developed Physical data models and created DML scripts to create

database schema and database objects.

. Migrated data from Heterogeneous Data Sources and legacy system

(Access, Excel) to SQL Server databases using SQL Server Integration

Services (SSIS) to overcome transformation constraints. Developed

Reports for business end users using SSRS.

. Played an active role during the requirements gathering, analyzing and

designing of the system in Graduate Admissions Office at the

University. Developed and Optimized Stored Procedures, Views, and User-

Defined Functions for the application.

. Responsible for routine tasks such as backups, restores, refreshing

databases as per requirements.

. Configured Database Mirroring with high performance and high safety

(with and without automatic failover) mode.

. Troubleshoot for performance related Issues in the servers using DBCC

commands and DMVs.

. Created Logins and Roles with appropriate Permissions and implemented

security at server and database level.

. Monitored disk space issues on the servers. Configured Snapshot, Merge

and Transaction replication for high availability.

. Implemented log shipping and scheduled jobs and alerts using SQL

Server agent.

. Created and maintained clustered and non-clustered indexes; Rebuild

and reorganized indexes; Found missing indexes and dropped unused

indexes to increase performance.

. With SQL Server, performed backups (Full, Diff, Transaction log) and

restores.

. Implemented High Availability and Disaster Recovery solutions with SQL

Server including Replication, DB Mirroring, Log Shipping and Failover

Clustering (Active-Passive).

. Used Database Engine Tuning Advisor to check for performance

suggestions.

Contact this candidate