| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
C: PHONE NUMBER AVAILABLE | Email: EMAIL AVAILABLE
Microsoft Certified Professional | Microsoft Certified Solutions Expert
(Data Platform) | Microsoft Certified Solutions Associate (SQL Server Street Address
and Street Address )
_____________________________
PROFESSIONAL SUMMARY
. Primed with almost 12 years of IT Expertise, that focuses on
Design\Administration\Management\Development of very large and complex
DBs up to 100TBs on different versions of SQL Server
(2012\2008R2\2008\2005\2000).
. Experience in implementing Business Intelligence Tools (SSAS, SSIS and
SSRS) for application teams like installing, configuring, deploying
Packages, Reports and Cubes and SharePoint 2007.
. Experience in Project Management for diverse information technology
projects, developing\managing project plans,
project\strategic\schedule planning, systems analysis and
troubleshooting, quality control, forecasting, managing milestones and
deliverables on schedules, tracking results and closing.
. Expert in understanding infrastructure and network architecture and
designing, installing, configuring, patching and upgrading Windows and
SQL Server Clusters (Active-Active\Active-Passive) and Stand-Alone
Servers.
. Expertise in designing Disaster Recovery Procedures and setting up
backup policies.
. Experience in setting up High Availability techniques (Log Shipping,
Database Mirroring, Failover Clustering and Replication).
. Expertise in handling migrations across servers\platforms and managing
Data Center Migrations along with managing security, logins, jobs and
maintenance plans.
. Expertise in T-SQL coding (includes writing Stored
Procedures\Triggers\User defined functions\Cursors\Views), performance
and database tuning, running DBCC checks, support and maintenance,
creating and implementing technical\operational plans and strategies.
. Support day-day operations by automating maintenance plans and SQL
server jobs and alerts using the Database Mail and SQL Server Agent
(to collect database statistics, database security, permissions,
backups, index rebuilds and DBCC checks).
. Troubleshooting performance\connectivity\database issues,
infrastructure bottlenecks and poor performing queries.
. Monitoring space and growth on databases and estimate and maintain
Fill Factors, capacity planning and implement database\table
partitioning based on necessity.
. Proven expertise for a broad range of industry domains like
Government, Financial, Healthcare and Aeronautical and experienced in
hiring, training, motivating new employees and building customer
relationships.
. Excellent oral, communication, written and progressive management
skills with business and technical vision and ability to perform
business analysis and document specifications focused on delivering
solutions that create business value.
CORE COMPETENCIES
|Database |SQL Server 2012\2008R2\2008\2005\2000, Business Intelligence |
|Technologies |2012\2008R2\2005, MOSS 2007 |
|SQL Server Tools |Management Studio, Configuration Manager, Query Analyzer, Error |
| |Reporting, Business Intelligence Development Studio, Database |
| |Engine Tuning Advisor, Profiler, Activity Monitor |
|SQL Server Skills|Disaster Recovery, High Availability, Log shipping, Failover |
| |Clustering, Database Mirroring, Replication, Always On High |
| |Availability, Upgrading\Patching SQL Server, Data Center |
| |Migrations, Database Migrations, Database Design & Security, |
| |Performance Monitoring and Tuning, Backup and Restore, |
| |Partitioning, Indexing |
|BI Tools |SSAS, SSIS, SSRS, DTS |
|Languages |SQL, T-SQL, PL/SQL, MySQL |
|Operating Systems|Windows Server 2012\2008R2\2003\2000\XP, Red Hat Linux, Unix |
|Software Tools |VMWare, Lotus Notes, BMC Remedy, BMC Footprints, Jira, Idera, |
| |Lite speed, Ignite, Fog light, Spot Light, Red Gate, Erwin, SQL |
| |Loader, Toad, MS Visio, Tidal, Microsoft Office Suite, Microsoft|
| |Project |
ACCOMPLISHMENTS
|Microsoft Certified |Microsoft SQL Server |
|Professional (MCP) | |
|Microsoft Certified Solutions |Data Platform - Microsoft SQL Server |
|Expert (MCSE) | |
|Microsoft Certified Solutions |Microsoft SQL Server 2012 and 2008 |
|Associate (MCSA) | |
|Technical Institute of America |Project Management Professional |
|& ProXalt |Training |
|Microsoft Certified IT |Microsoft SQL Server 2008 Database |
|Professional (MCITP) |Administrator |
|Microsoft Certified Technology |1) Microsoft SQL Server 2008 BI |
|Specialist (MCTS) |Development and Maintenance |
| |2) Microsoft Office SharePoint Server |
| |2007 Configuration |
|Master's Degree |Computer Science - New York Institute |
| |of Technology, NY |
PROFESSIONAL EXPERIENCE
Sr. SQL DBA - ConEd, New York (Oct 2014 - Current)
Responsibilities:
. Plan\Document POCs for implementing new technology enhancements.
. Install and Configure Windows and SQL Server Clusters 2012\2008R2 in
attended\unattended modes, update service packs and troubleshoot
installation errors and implement fixes.
. Install and configure BI Tools based on application requests on
Clustered and Standalone Servers.
. Plan and Set up High Availability Procedures like Failover Clustering,
Database Mirroring, Log Shipping and Always On Availability Groups.
. Implement Backup policies, Disaster Recovery plans (using Full,
Differential and T-Log Backups) and implement Backups for Analysis
Services Databases.
. Set up maintenance plans\SQL Server jobs\alerts for backups\DBCC
checks\history cleanup\heartbeat\server reboot\index rebuilds.
. Plan and implement data center migrations across multiple databases
and transfer logins, linked servers and SQL jobs.
. Reverse roles in case of databases that are set up with high
availability techniques and sync databases.
. Support after migration and maintain record of tracked bugs and fixes
implemented for lessons learnt.
. Work with application teams to support deployments, production
rollouts through various phases and Project GO-LIVEs.
. Work on day-day operations to support high transactional environments
and performance issues, support day-day operations for activities like
database security, permissions, backups, index rebuilds, DBCC check,
blocks, locks, deadlocks and poor performing queries.
. Supporting OLTP\OLAP systems and BI\ETL implementations and
enhancements and deploying T-SQL code, SSIS packages, SSRS reports,
configuration files and SSAS Cubes on Data warehousing environments.
. Setup maintenance Solution strategies that sync databases over Prod
and DR environments via backup file transfers.
. Monitoring Servers and DBA support queue for Database requests as part
of a team and provide support when required.
. Troubleshooting performance\connectivity\database issues, working with
infrastructure team for hardware issues and server performance tuning.
. Plan for Capacity\Growth and storage by estimating database growth.
. Documenting all installation, best policies, implementation procedures
and lessons learnt for all servers for future reference.
Lead SQL DBA - A+E Networks, New York (Feb 2014 - Sep 2014)
Responsibilities:
. Manage Projects and project management documentation from planning
through closing phases.
. Architect, planned and implemented Data Center Migration Project with
multiple clustered servers comprising 100TB of data.
. Installed and Configured Windows Clusters and Install SQL Server
Clusters 2012\2008R2 in both attended and unattended modes and also
updating patches and service packs.
. Installed BI Tools, Idera and LiteSpeed on Clustered and Standalone
Servers.
. Implemented Backup policies, Disaster Recovery plans using Full,
Differential and T-Log Backups using LiteSpeed and Backup plans for
Analysis Services Databases.
. Planned and Set up High Availability Procedures like Failover
Clustering, Database Mirroring, Log Shipping and Always On High
Availability.
. Set up maintenance plans and SQL Server jobs for backups, database
integrity checks, history cleanups and index rebuilds.
. Planned and implement migrations and transfer logins, linked servers
and SQL jobs.
. Worked with application teams to support deployments, production
rollouts and Project GO-LIVEs and fix bugs.
. Worked with application teams for day-day operations to support high
transactional environments and performance issues.
. Supported OLTP\OLAP systems and BI\ETL implementations and
enhancements and deploying T-SQL code, SSIS packages, SSRS reports,
Configuration files and SSAS Cubes on Data warehousing environments.
. Refreshed Dev and Test environment data on a regular basis and fixing
logins.
. Configured alerts to ensure there are no failures on all servers and
fix issues in case of alerts.
. Monitored Servers using Idera and Heartbeat and Jira for Database
requests as part of a team and provide 24*7 on-call support when
required.
. Troubleshoot performance\connectivity\database issues, working with
infrastructure team for hardware issues and server performance tuning.
. Supported day-day operations for activities like database security,
permissions, backups, index rebuilds, DBCC check, blocks, locks,
deadlocks and poor performing queries.
. Planned for Capacity\Growth and storage by estimating database growth.
. Planned and prepare POCs for implementing new technology enhancements
for future implementations.
. Documented all installation and best policies and implementation
procedures for all servers for future reference.
. Gathered lessons learnt and document issues and prevention actions for
future projects.
. Managed 24*7 support during production rollouts and operational
support.
Lead SQL DBA - Barnes & Noble College, New Jersey (Jun 2013 - Jan 2014)
Responsibilities:
. Installed SQL Server 2012 on Failover Clusters and Standalone Servers
and updated service packs on Prod, Dev and Test Environments.
. Install BI Tools and Ignite on Clustered and Standalone Servers.
. Managed Database Migration Project and document appropriate policies
and procedures from planning through closing phases.
. Planned and Implemented Database Migration Project with multiple
clustered servers comprising high transactional environments upto 8TB.
. Configured servers according to company standards and implemented DR
plans.
. Implemented Backups and Disaster Recovery plans using Full and T-Log
Backups.
. Planned High Availability Techniques like Failover Clustering, Log
Shipping, Replication and Database Mirroring.
. Worked with application teams to support deployments and Project GO-
LIVEs, BI\ETL implementations and enhancements and deploying T-SQL
code, SSIS packages, SSRS reports, Configuration files and SSAS Cubes
on Data warehousing environments.
. Set up maintenance plans and SQL Server jobs for backups, database
integrity checks, history cleanups and index rebuilds.
. Supported daily operations for security, backups, index rebuilds,
deadlocks and poor performing queries.
. Implemented migrations to move DBs to New SQL versions and across
Physical to Virtual Machines and transfer logins, linked servers and
SQL jobs.
. Created SSIS packages for logins and other objects transfer for
migrations.
. Refreshed Dev and Test environment data on a regular basis and fixing
logins.
. Expertise with table partitioning on relational data warehousing.
. Ran DBCC check commands on regular basis for Server maintenance and
troubleshoot performance and database issues.
. Configured alerts to ensure there are no failures on all servers and
fix issues in case of alerts.
. Implemented database security policies for creating and maintaining
users, groups and their roles.
. Set up Database and Server tuning and performance tuning by
implementing suitable optimizations.
. Monitored Footprints queue and resolve tickets as part of a team.
. Provide 24*7 on-call support when required.
Database Specialist - NYC DoITT, New York (Apr 2012 - May 2013)
Responsibilities:
. Installed and configured SQL Server 2012\2008R2, BI Tools, SpotLight
on Failover Clusters and Standalone Servers and updating service
packs.
. Configured servers according to company standards and installing SSL
certificates.
. Set up maintenance plans and SQL Server jobs like full daily backups,
hourly Transactional Log backups, database integrity checks, history
cleanups and index rebuilds.
. Implemented migrations to move DBs to New SQL versions and across
Physical to Virtual Machines and transfer logins, linked servers and
SQL jobs.
. Designed Relational Databases as per client requirement and their
input data flow.
. Planned and implemented application database code objects (Tables,
Views, Stored Procedures, Triggers, Cursors, etc.).
. Managed multiple databases and data warehouses for various
applications of data around 5TB.
. Planned and setting up high availability and Disaster Recovery
procedures like Clustering, Replication, Mirroring and Log Shipping
based on requirement.
. Support day-day operations for activities like database security,
permissions, backups, index rebuilds, DBCC check, blocks, locks,
deadlocks and poor performing queries.
. Deployed SSIS Packages, SSRS Reports, SSAS Cubes from Test to
Production.
. Implemented database security policies for creating and maintaining
users, groups and their roles.
. Set up Database and Server tuning and performance tuning by
implementing suitable optimizations, appropriate indexes and keys and
work on capacity planning.
. Involved in Administration of SharePoint Services.
. Monitored Remedy SQL DBA queue and resolve tickets as part of a team
and provide 24*7 on-call support when required
Lead SQL DBA - PineBridge Investments, New York (Apr 2011 - Mar 2012)
Responsibilities:
. Installed and configured SQL 2008R2, Failover Clustering, Replication
and service packs.
. Documented all changes for the SDLC and notes for various issues for
future references.
. Configured servers according to Business Applications and set up
maintenance plans and SQL Server jobs like full daily backups, history
cleanups and index rebuilds.
. Planned and implemented migrations to move DBs to New SQL versions.
. Plan, design and implement application database code objects for
applications and Database\ Table partitioning for easy management.
. Planned and set up high availability and Disaster Recovery procedures
like Clustering and Replication.
. Managed multiple instances and VLDBs on different environments.
. Deployed SSIS Packages, SSRS Reports, SSAS Cubes from Test to
Production.
. Configured alerts to ensure there are no failures and fix issues in
case of alerts.
. Implemented database security policies for creating and maintaining
users, groups and their roles.
. Run DBCC check commands on regular basis for Server maintenance.
. Tuned Databases and Server performance.
. Monitored DB Support queue and troubleshooting tickets.
. Created system for table synonyms, capturing, reporting and correcting
error data.
. Worked as part of a team and provide 24*7 on-call support when
required.
Lead SQL DBA - JP Morgan Chase, New York (Jun 2010 - Mar 2011)
Responsibilities:
. Gathered Client requirement, analyzed all stages of SDLC and
documented project and coding specifications and planned deliverable
schedule.
. Installed and configured SQL Server 2008R2, BI Tools, Replication and
Service Packs.
. Responsible for all database architecture including planning and
design of Data Warehouse of 8 TB.
. Implemented application database code objects for applications.
. Migrated databases and transferred jobs, logins and objects from Old
to New Servers.
. Implemented various SSIS Tasks and Data Flow Transformations to build
packages and implemented Package Configurations and deployed Packages
on different environments.
. Planned Disaster Recovery and implemented Tasks like backup/restore.
. Planned High availability for Production environment and implemented
cost effective techniques (Replication, Log Shipping, Database
Mirroring and Clustering) as per client requirement.
. Created Maintenance Plans, Scheduling jobs, alerts and notifications
with SQL agent and configuring Linked servers for data access between
different servers.
. Deploying SSIS Packages and SSRS Reports from Test to Production.
. Managing SSAS environments and monitoring the servers.
. Implemented Data Archival techniques periodically to ensure database
is not growing constantly.
. Monitored Quality Center for defects and bug-fixes and managing Onsite
and Offshore teams and providing 24*7 call support for the Critical
issues.
Sr. SQL DBA - Thomson Reuters, New York (Jul 2008 - Apr 2010)
Responsibilities:
. Installed and configured SQL Server 2008, Replication and Clustering
and applied Service Packs.
. Documented all stages of software development life cycle (SDLC) for
the project.
. Designed and developed Data Warehouse, Data marts with Business
Intelligence tools.
. Implemented Backups, Restore, Replication and Clustering to ensure
higher availability.
. Designed migration strategy and database mappings from Oracle to SQL
Server 2008.
. Designed SSIS packages, tested and deployed to Production for various
application databases.
. Developed SSRS reports, tested and deployed to Production for
dashboard reporting.
. Scheduled jobs, created alerts and notifications with SQL agent and
configured Linked servers.
|
