Sql Server Data

Prashant K

SUMMARY:

Six (*+) years of IT experience in Database Administration, Design, Development, Installation and Support of MS SQL Server 2012/ 2008 R2/ 2008/ 2005 in Production, Testing and Development Environments.

Expertise in MS SQL Server Installation, Upgrade, Configuration, Migration and Maintenance.

Extensive experience in T-SQL Programming in developing Stored Procedures, Indexes, Views, Triggers, User defined Functions, Cursors, Derived tables, Common Table Expressions (CTEs) and Complex Queries involving multiple tables inner and outer joins on SQL Server 2005/2008/2008 R2/2012.

Expert in Backup and Restore of the Databases.

Expert in SQL Server Clustering, implementing Active/Active and Active/Passive clustering.

Knowledge on Always-On availability groups.

Hands on experience in maintaining Replication (Snapshot, Transactional, Merge and Peer-Peer), Log Shipping and Mirroring as Disaster Recovery Procedures.

Experience in SQL Server Performance Tuning, client/server connectivity, Query optimization and running Database Consistency Checks using DBCC Commands.

Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors.

Experience in DB Security by creating logins, users, roles, and assigning permission to them.

Experience in using SQL Server Profiler and Activity Monitor to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.

Expert on monitoring disk space and memory optimization.

Excellent in creating SSIS Packages for integrating data using various connection managers (OLE DB, Flat file, ADO.NET, Excel) from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task, Conditional Split, Merge, Sort, Bulk Insert, Union All, etc.

Experience in some basic development of coding in VB.NET, C# while working with SSIS.

Experience in scheduling the jobs for SSIS packages, Sending Alerts using SQL Mail.

Strong experience in SSRS development skills, experience including Tablix, Matrix, Chart, Graphic Score Card Reports, Sub-reports.

Developed complex Stored Procedures and views to generate various Drill-through, Drill-down reports, Parameterized reports and Linked reports using SSRS 2012/ 2008 R2/ 2008/ 2005.

Generated reports using MS Report Builder 3.0 tool.

Good knowledge with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, Facts, Dimensions, Partitions and Tables using SSAS 2012/ 2008 R2/ 2008/ 2005.

Very good knowledge in building Cubes using SSAS and MDX.

Experience in data Normalization, De-Normalization and Normal forms.

Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.

Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS:

Databases

SQL Server 2005, 2008, 2008 R2, 2012 and MS-Access 2007/2010

Database Tools

SQL Server Management Studio, SQL Server Profiler, SSIS, SSAS, SSRS, SQL Server Report Builder 3.0, MS Access, Business Intelligence Development Studio/SQL Server Data Tools, MS Visual Studio.

Languages

T-SQL, C#, VB.NET & XMLA

OS

Windows Server 2000/2003/2008/2012, Windows XP

Web Servers

Internet Information Server

Architecture

Relational DBMS, Client-Server Architecture, OLTP, OLAP

MS Office Tools

MS-Word, MS-Excel, Power Point, MS Access

EDUCATION:

Bachelor of Science - Tribhuvan University, Nepal

Diploma in Database Development - College of Software Engineering, Rajbiraj, Nepal

WORK EXPERIENCE:

EMC2, Southborough, MA (Jun-2015 to Present)

SQL Server DBA

EMC Corporation (EMC ), a global leader in IT and business transformation, sells data storage, information security, virtualization, analytics, cloud computing and other products and services that enable businesses to store, manage, protect, and analyze data in a more agile, trusted and cost – effective way. EMC has over 70,000 employees and is the world’s largest provider of data storage systems by market share. I am working closely with development, QA and BI teams, and my role includes database design, development and maintenance, performance monitoring, security management, building reports using SSRS and developing SSIS packages.

Responsibilities:

Installed and configured SQL Server 2012 on Windows 2008/2012 servers, applied service packs and security fixes in Clustered and Standalone environments.

Worked extensively in writing and debugging Complex Stored Procedures, Triggers, and Inner Joins, Outer Joins, Views and user-defined Functions.

Implemented end to end Replication for the real time data flow between the SQL Servers.

Implemented high availability solutions for mission critical SQL Server databases with Clustering and Mirroring.

Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.

Responsible for Query optimization and Performance tuning.

Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.

Designed and implemented Disaster Recovery site using SQL Server Log Shipping.

Managed server Logins, database Users and permissions.

Implemented Backup and Restore in SQL Server 2012.

Used Activity Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Involved in data migration from Oracle (PeopleSoft) to SQL Server 2012 using SSIS.

Involved in Changed Data Capture and Aggregations during ETL process.

Created SSIS packages for processing data and moving to staging area for massaging and data scrubbing.

Used Conditional split, Derived column and Data Conversion task for cleaning the data.

Implemented incremental loading as per the daily changes in source database and applied event handlers, checkpoints and error logging on the failure of packages.

Created reports, drilldown reports according to requirement and for day to day analysis purpose by creating stored procedure and views and deployed them on SSRS server.

Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.

Environment: Windows Server 2008/ 2012, SQL Server 2012, SQL Server Data Tools (SSDT) 2010, SSIS 2012, SSRS 2012, MS Excel 2010/2013, MS Visual Studio 2012.

MB Financial Bank, N.A., Rosemont, IL (Oct-2013 to May-2015)

SQL Server DBA

MB Financial Inc. is the Chicago-based holding company for MB Financial Bank, N.A. with over $15 billion in assets. For over 100 years, MB has been supporting and building deep and lasting relationships with middle-market companies and individuals with investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity. I was working on Re platform project and my role was to manage MS SQL Servers, develop and maintain databases, Performance tuning, disaster recovery and security management.

Responsibilities:

Installed and Upgraded from SQL Server 2008 R2 to SQL server 2012 on Various Production Servers.

Involved in programming complex SQL queries, stored procedures, views, user defined functions and triggers.

Actively involved in installing and managing multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.

Implemented and Monitored different types of Replication (Snapshot, Transactional, Merge and Peer-Peer).

Implemented database mirroring and log shipping for disaster recovery.

Scheduled and managed daily Jobs relating to data transfers, backup and restore.

Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Maintained database consistency with DBCC at regular intervals. Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

Experienced in Query optimization and Performance tuning.

Created Clustered and Non-Clustered Indexes to increase the performance of database.

Used SQL Profiler and Activity Monitor to enhance the performance of database servers.

Resolved Deadlocking, Blocking and locking issues by creating a trace using SQL Profiler.

Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of Users.

Managed the use of disk space, memory, processor and connection.

Environment: SQL Server 2008 R2/2012, MS Access 2010, T-SQL, Windows 2008/2012, MS Excel 2010/2013.

Election Commission, Nepal (Apr-2012 to Jul-2013)

SQL Server DBA

Election Commission of Nepal is a constitutional Election Management Body in Nepal. I was working in Information System Management Section of IT Division, and I was mainly involved in managing databases in SQL Server 2008/ 2008 R2 regarding Voter Registration and Political party registration.

Responsibilities:

Remote Monitoring of SQL Server 2008/2008 R2.

Migrated SQL Server 2008 to SQL Server 2008 R2.

Configured Database mail, Linked server and Database mirroring.

Created maintenance plan for regular database Full, Differential, and T-log backup.

Implemented Snapshot and Transactional Replication.

Successfully implemented High-Availability solution in SQL Server 2008/2008 R2.

Implemented disaster recovery for SQL Server Production Database as Failover or Standby servers.

Used Log Shipping Technique for warm backup solution for MS SQL Server databases.

Wrote complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.

Created Users and Roles, and managed security and permission of database.

Used Activity monitor and SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Responsible for enhancing database objects including Tables, Indexes, and Stored Procedures and SQL jobs.

Environment: SQL Server 2008/2008 R2, Windows 2003/2008, T-SQL, MS Excel 2007.

Swift Technology, Kathmandu, Nepal (Jan-2011 to Apr-2012)

SQL Server DBA

Swift Technology is a pioneer IT Service Provider in Nepal with outstanding experience in delivering custom database development, desktop, distributed and networked application design as well as development of various web components and projects.

Responsibilities:

Performed Installations and configuration of SQL Server 2005/2008.

Created new Tables, Indexes, Triggers, Static/Dynamic Stored Procedures, Cursors and User Defined Functions.

Developed and Maintained database architecture.

Job Scheduling, batch alert and E-mail notification setting.

Worked on DTS Packages, and used DTS Import/Export to transfer data between various SQL Server instances.

Performed Backup and Restore operations.

Implemented and monitored Replication, DB Mirroring and Log-shipping

Carried out Performance tuning and troubleshooting of SQL queries and stored procedures using SQL Profiler and Statistics I/O.

Transferred data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and MS Access to SQL Server 2005/2008.

Environment: Windows server 2000/2003/2008, SQL Server 2005/2008, BIDS, T-SQL, DTS, SSIS 2005/ 2008, MS Excel 2007, MS Access 2007/2010.

Himalayan Bank Ltd., Kathmandu, Nepal (Feb-2010 to Dec-2010)

Jr. SQL Server Developer

Responsibilities:

Created database objects like Stored Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2005.

Experienced in Debugging Stored Procedures and Triggers and Troubleshooting database issues.

Experienced in optimizing the database by creating various Clustered, Non-Clustered Indexes and Indexed Views.

Good experience with creating alerts, schema management, database reorganization, data loading, database maintenance and optimization.

Performed Backup and Restore of databases.

Configured Log shipping to create stand by environment.

Created and deployed Table, List, Charts, and Matrix Reports using SSRS 2005.

Perform data migration from MS Excel, MS Access and Flat files to SQL Server 2005 using ETL tools like DTS and BCP.

Environment: SQL Server 2000/2005, BIDS, DTS, TSQL, SSIS, SSRS 2005, Windows 2000/2003, MS Excel 2007.

Contact this candidate