SUMMARY:

• Extensive experience with SQL Server 2014, 2012 and 2008 R2.
• Expertise in complex query design, stored procedures, views and functions.
• In - depth knowledge of T-SQL including complex SQL queries.
• Solid understanding of RDBMS principles, database design and normalization.
• Vast knowledge in index design, T-SQL performance tuning techniques, T-SQL coding methods and best practices.
• Working knowledge in Service Broker, Analysis Services(SSAS), Reporting Services(SSRS), Integration Services (SSIS) and Clustering.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS (Data Transformation Services) package for data transfer between the two environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Exceptional understanding of Business Intelligence and Data Warehouse concepts.
• Experience in Batch process, Import/Export, Backup, Database Monitoring tools and Application support.
• Proficient in designing and creating databases, tables, views, stored procedures and triggers.
• Expertise in SQL Server Replication, Log shipping, Mirroring, Backup/Recovery, Disaster recovery and planning.
• Experience in using dynamic management views and functions (DMV & DMF).
• Good understanding on the SQL Server 2012 and 2014 mechanisms like Data compression, Online indexing, Contained Databases, Security principals and AAG.
• Strong communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.
• Configuring Log shipping and mirroring from Production to DR server.
• Scheduling and managing jobs on SQL Agent.
• Managing database object permissions, user accounts and passwords.
• Experience in Production server Database migration.
• Installation, configuration and upgrading of Microsoft SQL Server software and related products.
• Evaluate MSSQL features and MSSQL related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database tuning and performance monitoring.
• Application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Interface with MSSQL for technical support.

Confidential

SQL Server Developer & DBA

Responsibilities:

• Solving the request raised by user support.
• Facilitate application deployment and joint effort deployments.
• Meet the SLA (Service Level Agreement) established.
• Supported 24*7 production support and solved all kinds of critical problems.
• Good hands on Index Tuning Wizard and SQL Profiler.
• Experience with Business Intelligence Concepts like Data Reporting (SSRS) and Data Analysis (SSAS).
• Designed VLDB (Very large databases) using design methodologies like STAR Schema and Snowflake Schema.
• Experience in Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Designed, created and maintained databases in both development and production environment.
• Strong knowledge and experience in Script-writing, performing backups/recovery, database monitoring, and performance tuning using SQL Profiler, SQL DBCC commands and Dynamic Management Views (DMVs), and Windows Performance Monitor.
• Extensive experience in data migration projects.
• Extensively used the SQL LITESPEED tool by the Quest Software to restore the backups at object level for tables and at schema level and rebuilding the indexes at regular intervals for better performance.
• Monitored SQL server performance using profiler to find dead locks and blockings.
• Queried the databases using the Powershell scripts.
• Tuned, monitored, maintained & Scheduled SQL Server Jobs.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Worked on various production issues related to Slow Performance, Log Shipping failure, Backup Failure, Performance Troubleshooting.
• Implemented Always On Availability Groups (AAG) on SQL Server 2012.
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Exposure to ITIL requests such as Change, Problem, Service and Incident requests and optimal usage of these requests as per requirement.
• Used DDL trigger for Data base Auditing.
• Worked with Logical and physical models in Erwin (ETL).
• Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.
• Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.
• Designed ETL flows to extract data from CRM application and stored in MS-SQL DB.
• Maintained ETL jobs for OLAP cubes. Executed and supported ETL using MS-SQL Server
• Strong experience in mentoring team members and writing documentation.

Confidential

SQL Server Developer

Responsibilities:

• Designed, developed, tested, tuned, and implemented relational databases and procedural database code.
• Produced ad-hoc queries and developed reports to support business needs.
• Developed and maintained SQL scripts in Microsoft SQL Server.
• Planned, designed and implemented application database code objects, such as stored procedures and views.
• Built SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discussed solution options.
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Performed End to End SQL Server administrative tasks ranging from installing and configuring servers to setup and administer clusters, replication, log shipping etc.
• Excellent Report designer with SQL Server Reporting Service (SSRS).
• Maintaining the database consistency with DBCC at regular intervals.