Sql Server Project

Shekhar Mishra

Ph: +1-201-***-**** Email: *******.******@****.***

LinkedIn: http://www.linkedin.com/in/shekhar157

Experience Summary

Proactive and Innovative Experienced Database Administrator with extensive 12+ years’ experience within demanding environments in Finance, Insurance and Government Domain. Worked as Database Architect/Engineer/Administrator/Subject Matter Expert in past, experienced in leading Database Teams, development and engineering teams. Implementing latest DB options like, AlwaysON, PostgreSQL, Azure etc. Proven expertise in setting up, configuring, deploying and supporting MS SQL Server 2008 / 2012 / 2014 and 2016 Databases throughout the enterprise. Well versed with Data Migration, Always ON, Replication, Windows Cluster, VMWare, Consolidation, Capacity Planning. Database performance tuning server level and query level. Expertise in Replication, Windows Failover Cluster, Replication (Transactional/Snapshot). Supported OLTP as well as Warehouse systems, and great in issue analysis. Supported application in leveraged and for dedicated clients.

Skill Summary

Areas of Effectiveness:

Install, configure and Manage

Database Architect / Administration

SQL Tuning

Strong Analytical Background

Cloud Initiatives

TSQL/SPs/Views

Performance Tuning

Database Maintenance/ Security

Database Migration Expert

Database Consolidation

Team Lead

Resource Management

Data Modeling

SOX and Security compliance

SDLC

ITIL trained

Design and Document

Project Disciplines:

Insurance

Banking/Finance

Government

Healthcare

Identity Access Management

Leveraged

Skillset:

SQL Server 2008/2012/2014

Good Understanding SQL 2016

Cluster / Always ON / Mirroring

Replication/Log Shipping

HA and DR Planning

Oracle 7.3/8i

PostgreSQL/MS Access

AWS/Azure

SSIS/SSRS/SSAS

Programming Languages:

PowerShell Scripting

Batch scripting (CMDSHELL)

Middleware / Apps / BI:

SQL Server Reporting Services

Operating Systems:

Windows Server 2008/2012

Unix

Project Experience

Mphasis corporation Apr 2016 – Mar 2017

Project: aig

Role: Consultant - Database Architect

Working within the IAM (Identity Access Management) program and closely worked with PAM (Privileged Access Management) team. This team supposed to collect the all domain/local accounts across AIG and research for privileged accounts and make a control on these accounts using TPAM. DBA needs to work closely with PAM Operation team and management team for their different requirement.

Responsibilities:

●Database Architect for PAM Databases as well as collecting different dataset using auto discovery from different sources.

●Responsible for administration, maintenance and availability of enterprise Production SQL server environments including cluster, mirror and replication

●Performed Schema/Data Modeling for new features and requirements, build ER Diagrams using Erwin

●Managed replication between SQL Server to SQL Server and from Oracle to SQL Server.

●Worked in AGILE Environment, going through daily Scrum, bi-weekly iterations and deployments

●Performed SQL Tuning of existing code to enhance performance benchmark.

●Developed and implemented Data Refresh script using TSQL.

●Maintains database performance by calculating optimum values for database parameters, implementing new

releases, completing maintenance requirements, evaluating infrastructure.

●Reduced development time loss by implementing automated Data Refresh scripts using triggers.

●Worked with Core DBA team, implementing best practices for SQL Performance parameters

●Build scripts for Replication into Data warehouse for PAM Database

●Supported Transaction replication

●Planned migration of Dev SQL Database to Azure to reduce Dev operation’s cost

●Worked on migration SQL Server 2008R2 Warehouse to SQL Server 2012 Warehouse for better support

●Involve and implement the Windows Fail Over cluster and Always on for their High Availability and DR plan.

●Documented and mentored team with best practices for SQL coding, new features

●Monitoring and SQL/Instance tuning using IDERA and implemented recommendation

●SQL performance tuning, TSQL, Infrastructure, SQL profiling, post migration support, PowerShell scripting

●Regulars reports and charts for Management using Excel and Tableau.

Environment: SQL Server 2008R2/SQL 20012/SQL2014/SQL 2016, Oracle 12c(12.1.0.1), Windows 2012/Unix, PL/SQL, Transact-SQL, CLOUD, Erwin, Cluster, replication, BCP, Data warehouse, AWS, SSRS, SSIS, Service now

Mphasis ltd (India) Feb 2014 – Apr 2015

Project: Deutsche Bank

Role: Database Architect, windows 2003 remediation program

Nucleus Project, under which Bank planned for Data Center migration and Database upgrade for all their databases, which resides on Windows 2003 (Because MS has ended the support). Footprint included SQL Server 2000/2005/2008, planned to be all standardized to SQL Server 2008R2/2012/2014 databases were migrated and upgraded.

Responsibilities:

●Database Architect for Database Services, working on Data center consolidation/migration project building

●Supported SQL Server 2012/2014 on virtual environment.

●Installs revised or new systems by proposing specifications and documentation and coordinating installation requirements.

●Responsible for administration, analysis, design, and creation of new SQL server databases.

●Avoided business loss by implementing zero downtime migration of database

●Implemented High Availability solution using Data Guard and Single Node clusters having SRM failover

●Build Reporting Server in Grid Control for Capacity Planning, Incident Monitoring, Inventory

●Planned and executed migration across AMER/EMEA/ASIA region.

●Responsible for Identifies database requirements from customer/vendor and evaluating existing

systems and do a capacity plan for proposed systems.

●Defined steps to Automate patch installation on all the SQL Servers.

●Performed pre-migration testing by coordinating with different application/developer team.

●Monthly SLA calculation, Meeting stakeholders, performance reports, resource allocation and planning

●Defined backup and restore standards, DR planning, testing and documenting

●Coordinate with different development team for performance tuning on TSQL, SPs, and views and provide them the query plan. Also worked on the physical server performance tuning.

●Setup and Supported DR exercise using Windows Cluster and Always On and with auto failover across Data Center

●Monthly and Weekly reports and charts for Management using Excel

●Design, document, Configure and manage Transaction and Merge Replication.

Environment: SQL server 2008r2/20012/2014, SSMS, Replication, cluster, always on, service now, SSIS, SSRS, SSAS

Mphasis Ltd (India) Nov 2013 – Feb 2014

Project: Symantec

Role: Team Lead (Offline Data Center)

This role also includes evaluating specifications and requirements against available solutions. We need to interact within different infrastructure teams for Production Support and plan for new solution that comes in. Support model was onshore and offshore.

Responsibilities:

●Planning and execution for their Migration project from SQL 2000 to SQL 2005/2008R2.

●Worked with different Infrastructure team for continual database support in 24*7 environment.

●Planning and requirement collection for Design and Implementation

●Lead projects and efforts driven by database systems, such as database appliance and consolidation

●Manage and configure replication/cluster/log shipping for the production environment.

●Worked with different development team for performance tuning on TSQL, SPs, and views.

●Manage Database team of over 10 DBA, in respect of time management, shift planning and on call rotation. Also, primarily mentoring new team members to the environment.

●SPOC for SEV1/SEV2 issues and prepare RCA (Root Cause Analysis) and document it.

●Maintain documents and define policies for SOX compliance and internal audit.

●Document and improve existing processes related to operations and daily work

●Work with internal auditor for SQL Server hardening.

●Migration of SQL Server 2005 to MS SQL Server 2008/2012.

●Design and implementation of enterprise database architectures on MSSQL technologies

●Consultation for different new implementation.

●Present new solutions to the CAB meetings and get the approval to implement those changes to the production environment.

●Installation & Configuration of SQL Server 2008R2 and 2012 on cluster and standalone servers.

●Designing & Deploying databases for various front-end applications.

●Designing Backup & Recovery plans for point in time recovery.

●Setting up and maintaining Log Shipping.

●SQL Server Hardening as per the Client Policy.

●Performance Tuning & Monitoring (Tools Used: SQL Profiler & Windows Performance Monitor)

Environment: SQL Server 2000/2005/2008R2, Windows 2008, Cluster, Replication, Log Shipping.

Mphasis PTE Ltd (Singapore) Sep 2012– Nov 2013

Project: Info-Com Development Authority (IDA), Singapore

Role: Lead Database Engineering.

Responsibilities:

●Database Consolidation planning and implementation.

●Lead projects and efforts driven by database systems, such as database appliance and consolidation

●Design and implementation of enterprise DB architectures on MSSQL technologies for SQL Consolidation.

●Install, configure, manage and maintain multiple MS SQL Server 2000/2005/2008R2 and Oracle

●Install and configure cluster on- multiple VMWare machines.

●Document and improve existing processes related to operations and daily work

●Worked with application/development team for query optimization and performance tuning .

●Worked on TSQL, SPs and views.

●Plan and consolidate different application under single clustered server.

●Document solution present the change into CAB (Change Assessment Board) for QA sessions.

●Implement and maintain SAN replication for SQL Server Instances as High Availability solution.

●Install, configure and maintain Windows Failover cluster for SQL Server.

●Manage Memory, CPU and I/O performance as well as assure database health

●Perform back up, restoration and upgrades servers (including DR)

●Perform replication, clustering, performance tuning and optimization

●Control operational procedures and support

●Evaluate specifications and requirements against available solutions

Environment: SQL Server 2000/2005/2008R2, Windows 2003/2008, Remedy, Cluster, VMWare, Replication

Mphasis Ltd (India) Mar 2008 – Sep 2012

Project: Leverage Support (Bank of America/NASD/NYSE etc.)

Role: Team/Tech Lead (SQL DBA)

Responsibilities:

●Follow banking and financial procedure and mentor team.

●delivery and Sox complaisance.

●24 * 7 Production Support and follow Escalation Procedure appropriately

●Install, configure and maintain SQL Server 2000/2005/2008R2 on windows clusters and VMWare machines.

●Database migration and upgradation on cluster environment.

●Domain and SAN migration over the large cluster of multiple SQL Servers.

●Follow up with the ITIL Process.

●Ensure Database availability, usability, recoverability and other requirements.

●Be flexible to support Non-scheduled maintenance and emergency situations

●Perform regular activities for the supported systems.

●Designing Backup & Recovery plans for point in time recovery.

●Setting up and maintaining Log Shipping, mirroring and Replication.

●SQL Server Hardening as per the Client Policy.

Environment: SQL Server 2000/2005, Windows 2003/2000, Remedy, Cluster, VMWare, Replication

Mphasis an EDS Company (India) Dec 2006 – Mar 2008

Project: East Hub Leveraged Support

Role: Senior SQL DBA

Responsibilities:

●Effective and timely resolution of on call issues within SLA

●Follow Escalation Procedure appropriately and Document database support information

●Ensure Database availability, usability, recoverability and other requirements.

●Be flexible to support Non-scheduled maintenance and emergency situations.

Environment: SQL Server 2000/2005, Windows 2003/2000, Log Shipping, replication.

BirlaSoft (India) May 2006 – Dec 2006

Project: Monster (USA)

Role: Senior Software engineer

Responsibilities:

●SQL Server Production Support.

●Install, configure, manage and maintain multiple MS SQL Server.

Environment: SQL Server 7.0/2000.

SRIT Ltd (India) Jan 2006 – May 2006

Project: RCARE Healthcare Product

Role: DBA

Responsibilities:

●Data Migration for Healthcare product.

●Install, configure, manage and maintain multiple MS SQL Server.

Environment: SQL Server 7.0/2000.

Alankit Assignments Ltd (India) Jan 2001 – Jan 2006

Role: System and Network Administrator

Responsibilities:

●System Administrator support for LAN/WAN/VSAT/Routers/Switches and Installation of Windows Server 2000 and Windows NT/XP/95 for different work station.

Environment: WAN/LAN, Windows, SQL Server

Education

Masters in Information Technology - 2006

Punjab Technical University, India

Masters in Commerce - 2000

MJP Rohilkhand University, India

Bachelor in Commerce - 1998

MJP Rohilkhand University, India

Certification/training

MCSE (Microsoft Certified Solutions Expert) Data Management and Analytics (2017)

MCITP SQL 2005 Database Administrator (2009)

Contact this candidate