We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

NC

SUMMARY:

  • Around 10Years of extensive experience in Information Technology, as a SQL ServerDBA (SQL 2000/2005/2008/ R 2/2012/ 2014/2016/2017 ) in Development, Test and Production Environments under 32 - bit and 64- bit environments.
  • Experience with ORACLE database administration (Oracle 10g/11g) onUNIX, Linux and Solaris platforms.
  • 24 X 7 Production Database on Call Support.
  • Experience in T-SQL Programming, Integration, Reporting and Analysis services.
  • Experience in space allocation, database migrations and database security.
  • Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/ 2008R 2/2012/ 2014/2016/2017 databasesand Oracle 10g/11g databases.
  • Expertise withmigrating\upgrading servers using in place and side by side upgrade.
  • Experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.
  • Extensive experience with disaster recovery and high availability SQL Server solutions, using Always-on High-Availability groups, SQL Server clustering,Mirroring, Log shipping and, replication.
  • Experience with Oracle Data guard.
  • Expertise in implementing and maintaining Snapshot, Transactional and Merge replication in SQL Server 2000,2005,2008,2008R2,2012, 2014and 2017.
  • Installed, configured and administeredmulti Clustered instanceswithActive/Active, Active/Passive environments.
  • Experience with policy based management system with central configuration server,Resource Governor.
  • Expertise in creation and maintenance ofProcedures, Triggers, Cursors and Functions.
  • Experience in BI development environment using Microsoft DTS, SSIS, SSRS, and SSAS.
  • Experience with RMAN backup and restore procedures.
  • Extensive experience in backup and restore procedures using native and third-party Backup tools (Net backup,lite speed) products.
  • Experience with Table Space Management.
  • Extensive experience in controlling the user privileges, roles, monitoring the security and Audit issues in SOX, PCI and FDA environments.
  • Experience in deploying and schedulingSSIS packages as jobs in MS SQL server 2005/2008/R 2/2012/2014/2016.
  • Proficient knowledge of creating feeds from OLTP to OLAP systems.
  • Experience with SharePointinstallation, configuration.
  • Experience in writing bcp, Bulk load and SQL Loader scripts for Extract, Transformation and Loading of data.
  • Extensive experience in using SQL profiler,ORACLE Enterprise Manager,System monitor, Query analyzer and Process explorer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code.
  • Experience with working in VMware, ESX andHyper-V virtual environments.
  • Experience with Power shell scripting.
  • Experience in database and system performance tuning and query optimization.
  • Knowledge on SQL Server service broker.
  • Knowledge with HTML, XML, VB Script, Java Script, ASP, IIS, web site design, Telnet, software development life cycle.
  • Knowledge on Microsoft Azure and Amazon webservices Relational Database services cloud platforms.

TECHNICAL SKILLS:

Database: M.S Access, SQL Server 2000, 2005, 2008/R2, 2012, 2014, 2016, 2017, Oracle 9i, 10g/11g.

O/S: Windows 2000/2003/2008 / R2/2012 and Windows NT, UNIX, LINUX, Solaris

Language: SQL, PL\SQL, T-SQL and C, C#, VB and .NET 1.1/2.0/3.5/4.0.

Tools: SQL Developer, IIS, MS OFFICE 2000/2003/2010 , Lite Speed, VERITASNet Backup, Erwin, TOAD, Control-M, WSS, MOSS 2007/2010, Tivoli, HPPolyserve, HP OVO, SQL Compare, SQL Compliance Manager, SQL diagnostic Manager, SQL DB Control and Fog light.

SQL Services: SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services, SSAS(SQL Server Analysis services).

PROFESSIONAL EXPERIENCE:

Confidential, NC

Sr. SQL Server DBA

Responsibilities:

  • Working collaboratively with application teams and DAN/UDS/EDM LOB DBA teams to migrate Non-EDM Supported DBs to EDM supported environments.
  • Installing and configuring SQL server 2012, 2014, 2016 and 2017 on Windows servers in Clustered andNon-Clusteredenvironments.
  • Responsible forPlanning/Upgrading servers from SQL Server 2008/R2/2012 to SQL server 2014/2016/2017 inDev, QA, UAT and Production environments.
  • Configuring and managing the SAN replication.
  • Implementing high availability with Always on Availability groups and failover clustering.
  • Responsible to configure and Monitor DB Maintenance plans like Backups, index maintenance, update statistics and DB integrity checks.
  • Responsible to provide On Call Production support for SQL Serverdatabases.
  • Providing support for the Clustered and Non-Clustered SQL Server 2016/ 2014/2012/2008/ R2instances in Production, Development and UAT environments.
  • Configuring and managingtransactional replication.
  • Developing PowerShell scripts to automate DBA maintenance tasks.
  • Managing Disaster Recovery solutionsLog Shipping and DB mirroring for BCP/DR servers
  • Responsible for DB deployments and code reviews.
  • Involved in capacity planning to estimate storage needs.
  • Responsible to grant Object level permissions to users through DB roles.
  • Responsible to install SQL server patches and hot fixes.
  • Resolving Production performance issues by analyzing query Execution plans.

Environment: Windows Server 2008/2012/2016 , SQL Server 2017/ 2016/ 2014/2012/2008/ R2 SSRS, SSIS, SSAS, Oracle 10g/11g/12c, RMAN, Solaris 10/11, Unix, OEM, Toad, Secure CRT, Putty, IIS, CSS, HTML, VB.Net, C#, ASP.Net 2.0/3.5/4.0/4.5 , ADO.Net,SCOM, HP OVO, SQL Compliance Manager, Red Gate SQL Compare.

Confidential, PA

Sr. SQL Server DBA

Responsibilities:

  • Installed and configured SQL server 2012 and 2014 on Windows servers in Clustered and Non Clustered environments.
  • Upgraded servers from SQL Server 2005/2008/R2 to SQL server 2012 and 2014 inDev, QA, UAT and Production environments.
  • Implemented high availability with Always on Availability groups and failover clustering.
  • Designed and implementedDisaster Recovery solution using Log Shipping and maintaining DR servers
  • Configured and managedtransactional replication.
  • Involved in database design, database standards and T-SQL code reviews.
  • Responsible for ad-hoc DB deployments and Monthly release DB deployments.
  • Rebuilding/Reorganizing indexes to reduce fragmentation.
  • Provided support for the Clustered and Non-Clustered SQL Server 2014/2012/2008/ R2/2005 instances in Production, Development and UAT environments.
  • Responsible to configure and monitor DB Maintenance plans like Backups, index maintenance, update statistics and DB integrity checks.
  • Developed power shell scripts and stored procedures for monitoring SQL instances for any errors, failures, dead locks and low disk space.
  • AnalyzedDeadlocks and provide recommendation.

Environment: Windows Server2008/2012, SQL Server 2014/2012/2008/ R2/2005 SSRS, SSIS, IIS, CSS, HTML, VB.Net, C#, ASP.Net 2.0/3.5/4.0/4.5 , ADO.Net

Confidential, MD

Sr. SQL Server DBA

Responsibilities:

  • Installed and configured SQL server 2008 R2 on Windows servers.
  • Involved in Planning/Upgrading servers from SQL Server 2005/2008/R2 to SQL server 2012 and 2014 inDev, QA, UAT and Production environments.
  • Responsible to provide On-Call DBA support.
  • Configuring and administrating transactional replication on multi-terabyte database in production servers to other production servers.
  • Created and maintained Server-Level/Database-Level logins, users, roles and configuring Authentication Modes in Dev, QA, UAT and Production environments.
  • Involved in database design, database standards and T-SQL code reviews.
  • Responsible for ad-hoc DB deployments and Monthly release DB deployments.
  • Migrated databases using Detach/Attach and Backup/Restore methods.
  • Configured and Migrated the SSRS Reports in different environments.
  • Designed and implemented a strategy to manage data across linked servers.
  • Deployed and Migrated SSIS Packages and SSAS cubes.
  • Rebuilding/Reorganizing indexes to reduce fragmentation.
  • Configured and documented database Backup and Maintenance Plans for multi-terabyte Databases.
  • Responsible to configure and monitor DB Maintenance plans like Backups, index maintenance, update statistics and DB integrity checks.
  • Developed scripts for monitoring SQL instances for any errors, failures, dead locks and low disk space.
  • Configured SQL server alerts to monitor and notify SQL server errors and failures.
  • Responsible to install SQL server patches and hot fixes as needed.
  • Troubleshoot Blocking and Deadlocking issues
  • Involved in capacity planning to estimate storage needs throughout the environment.
  • SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing SQL queries and stored procedures.
  • Securing SQL server instances and databases by granting limited permissions to users and application logins and revoking permissions that are no longer required by conducting quarterly security audits.

Environment: Windows Server2008/2012, SQL Server 2014/2012/2008/ R2/2005 SSRS, SSIS, IIS, CSS, HTML, VB.Net, C#, ASP.Net 2.0/3.5/4.0/4.5 , ADO.Net, Lite Speed 6.5, SQL Compliance Manager, SQL Diagnostic Manager, SQL DB Control and Fog light

Confidential, NC

Sr. SQL Server/OracleDBA

Responsibilities:

  • Installed and configuredSQL Server 2008/R2 in Production and Development environments.
  • Successfully upgraded servers from SQL Server 2000/2005 to SQL Server 2008/R2 on Development, Testing and Production Environments.
  • Installed and configured Oracle 10g/11g Databases in production and Test environments.
  • Developed and Automated Database Backup Scripts and configured alerts to report any errors for SQL server databases.
  • Installed and configuredMulti Node\multiple instanceclustered and nonclustered environments.
  • Developed and deployedRMAN backup scripts to perform full backup and archive log backups to support point in time recovery of databases in case of any production issues.
  • Createdshell scripts for Database maintenance tasks and automating them with associated Cron job entries.
  • ConfiguredOEM and user defined alerts to monitor Oracle Databases.
  • Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005/2008/R2.
  • ImplementedLog Shipping in SQL 2005/2008/R2 from Primary Server to Standby Server to support Disaster Recovery Solutions.
  • Creating Logins and Roles with appropriate permissions.
  • Responsible to provide 24x7 DBA & Production support for SQL Server and Oracle databases on Clustered Serversto achieve optimum performance.
  • Developed various PL-SQL/T-SQLStored Procedures/Functions.
  • Supporting SharePoint backend databases.
  • Created Linked Servers and maintenance plans which include Database Backups, database maintenance checks like shrink database, re-organizing and rebuilding of Indexes.
  • Worked with BCP and SSIS Packages for migrating data across different servers.
  • Involved in SQL Server Performance Tuning of Database, T-SQL and operating system level and suggested system upgrade like disk, processor, and memory.
  • UsedPerformance Monitor for monitoring memory, processor, and Disk I/O and user connections.
  • Managedsecurity tasks like granting and revoking permissions.
  • Installedpatches or hotfixes to the database as needed.

Environment: SQL Server 2000/2005/2008/ R2 and Windows 2000/2003/2008 / R2, OVO, Oracle 10g/11g, RMAN, Solaris 10, Unix, OEM, Toad, Secure CRT 6, Putty, Humming Bird 2007, Visual Basic 6.0, VERITAS Net backup, SQL Lite Speed 5.2, ASP.Net 2.0/3.5/4.0, C#.Net, SSIS, SSAS,SSRS, WSS, SharePoint 2007/2010.

Confidential, NJ

SQL Server DBA

Responsibilities:

  • Installed and configured SQL Server 2005, 2008 in Development, Testand Production environments as per SOX Standards.
  • Successfully upgraded servers from SQL Server 2000 to SQL Server 2005 and SQL Server 2008/R2.
  • Involved with SharePoint Installations, Configurations.
  • Involved in Gathering User Requirements and Technical Specification Documentation.
  • Administering SharePoint backend databases.
  • Upgraded databases from MS SQL Server 2000/2005 to MS SQL Server 2008/R2.
  • Involved in database design, database standards and T-SQL code reviews.
  • Migrated databases using Detach/Attach and Export/Import wizards.
  • Involved with Datacenter migrations.
  • Installed, configured and administered Multi node and Multi instance Clustered servers in Active/Active, Active/Passive environments.
  • Installed and configured snapshot, transactional and Merge replication for production servers to another production servers available in remote locations
  • Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous updates with witness server.
  • Installed, configured and deployed the Reports along different servers using SSRS.
  • Designed and implemented a strategy to manage data across linked servers.
  • Successfully implemented Database Mirroring with High Availability Mode in SQL 2005 and SQL 2008.
  • Implemented Log Shipping in SQL 2005 and SQL 2008 from Primary Server to Standby Server to support DR Solution.
  • Involved in Performance tuning, optimization of stored procedures and queries.
  • Rebuilding indexes on tables using various SQL Server commands to reduce fragmentation.
  • Creating Logins and Roles with appropriate permissions.
  • Prepared and documented database Backup and Maintenance Plans.
  • Responsible for Monitoring and administering HP Polyserve clusters.
  • Providing support for the Production, Development and QA Servers for Clustered and Non - Clustered SQL Server 2008/2005/2000.
  • Using all the SQL Server tools for the Implementation and Administration of the databases. The tools include Performance Monitor, Profiler Trace, Database Tuning Advisor, Query Analyzer, SSMS, Data collector and policy based management.

Environment: SQL Server 2000/2005 and 2008 and Windows 2000/2003/2008 , HP Polyserve, Oracle 11g, Visual Basic 6.0, VERITAS Net backup, SQL Lite Speed 5.2, ASP.Net 2.0/3.5, C#.Net, DTS, SSIS, SSAS,SSRS, WSS, SharePoint 2007, Control-M 6.3/6.4 and Tivoli 6.

Hire Now