Sql Server Database administer
Resume:
Nagabhushanam obul
E-Mail: *************.*@*****.***
Mobile: 517-***-****
Professional Summary
Over 12+ years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2014/2012/2008R2/2005/2000 in Production, Reporting Services, Development environments & Replication and Cluster Server Environments.
Experience in Installations, Configuration and Maintenance of MSSQL2000/2005/2008r2/2012/2014.
Worked as a team member to provide 24x7 on-call production database support.
Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
Created documentations for Installation of SQL server 2005/2008R2/2012/2014 and configuration of High availability Solutions.
Experience in ITIL process (Incident, Service request, change and problem management) using BMC tool.
Knowledge on SAP HANA DBA.
Experience on Datacenter move, SQL Server2000 and Windows 2003 upgrade activities.
Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
Experience in Database Backup, Recovery with RTO and RPO.
Expertise in planning and implementing MS SQL server security and database permissions.
Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
Experience in deploying the SSIS packages and SSRS reports in Production environment.
Experience in Installing, Configuring and maintaining SQL Server Active/Active and Active/Passive clusters.
Configured the Always-on high availability technique in SQL server 2012 environment
Good experience with implementing DR solution, High Availability of database servers using replications and Log Shipping.
Experience in SQL server Migration from SQL server 2005 to 2008R2 and 2008R2 to 2012.
Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
Using Performance Monitor/Profiler/Extended Events to solve Dead Locks/Long running queries.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Administered, maintained, developed and implemented policies and procedures for ensuring the security and Integrity of the company database.
Monitoring the nearly 800 servers by accessing remotely and analyzing the databases size ranging from 1GB to 2TB.
Experience in investigating and applying necessary SQL Server database patches and installing service packs.
Technical Expertise:
Programming Languages
T-SQL, PowerShell
RDBMS
MS- SQLSERVER 2000/2005/2008R2/2012/2014.
Operating Systems
Windows server/2000/2003/2008R2/2012.
Tools
Red Gate, Idera, Lite Speed, Ignite, SDT and BMCRemedy
BI Tools
SSIS and SSRS.
Client: Boston Scientific, Minnesota Role: Sr. SQLDBA Duration: April’16–Till Date
Responsibilities:
Responsible for leading the Offshore\onshore group and supervise the Operational team, technically supervise a team work in all aspects.
Provided 24 x 7 and on-call Production support for the databases and application issues.
Performance tuning on long running T-SQL Queries in SQL server 2000/2005/2008R2/2012/2014.
Created SSIS packages for the extracting, transforming and loading the data from different systems into SQL Server 2008R2.
Deploy the SSIS packages and create jobs in SQL agent.
Developed SQL scripts/PowerShell script for maintaining administration tasks.
Worked and implemented the DR solution.
Build and Configured the Stage/Test and Dev environment based on customer requirements.
Worked on Cut-over activity on Prod and stage environments.
Worked on stage and Dev environment refresh with Prod environment.
Worked on moving and restoring the database backups from Prod to Test/Dev/Stage environments for testing activities.
Installed, configured and upgraded MS SQL Server 2005/2008R2/2012/2014.
Scheduled and applying monthly security patches on Production and Non-Production environments.
Monitoring and resolving Space issues, Jobs, Blockings and SQL related Virtual tickets.
Configured Transactional Replication, Merge Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
Experienced in resolving deadlock and blocking issues for concurrent users.
Client: MN State Judicial Branch, Minnesota Role: Sr.SQL DBA Duration: Dec’15-March16
Responsibilities:
Performance tuning on long running T-SQL Queries in SQL server 2012.
Monitoring and resolving Space issues, Jobs, Blockings and SQL related Virtual tickets.
Developed SQL scripts for maintaining administration tasks.
Worked on SQL server Migration from SQL server 2008R2 to 2012
Experienced in resolving deadlock and blocking issues for concurrent users using Extended Events, SQLProfiler.
Tuned the SQL queries using SQL profiler and involved in tuning the database.
Client: Boston Scientific, Minnesota Role: Sr.SQL DBA Duration: June’13–Dec’15
Responsibilities:
Work with Application teams, taking the requirements and architect a SQL Server to meet their application needs, then working with Server team to get either physical or Virtual server setup and SQL Server installed and configured
Provided 24 x 5 and on-call Production support for the databases and application issues.
Performance tuning on long running T-SQL Queries in SQL server 2000/2005/2008R2.
Created SSIS packages for the extracting, transforming and loading the data from different systems into SQL Server 2008R2.
Worked on SQL server Migration from SQL server 2005 to 2008R2 and 20082 to 2012
Deploy the SSIS packages and create jobs in SQL agent.
Worked on the Automation of administration activities using PowerShell script
Worked on Datacenter Move, SQL server 2000 and Windows 2003 upgrades activities.
Developed SQL scripts for maintaining administration tasks.
Worked and implemented the DR solution.
Build and Configured the Stage/Test and Dev environment based on customer requirements.
Worked on Cut-over activity on Prod and stage environments.
Worked on stage and Dev environment refresh with Prod environment.
Worked on moving and restoring the database backups from Prod to Test/Dev/Stage environments for testing activities.
Installed, configured and upgraded MS SQL Server 2005/2008R2/2012/2014.
Implemented SQL standards in writing stored procedures, Triggers, Views and locking issues.
Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions
Worked on Active directory in Windows 2008R2.
Scheduled and applying monthly security patches on Production and Non-Production environments.
Monitoring and resolving Space issues, Jobs, Blockings and SQL related Virtual tickets.
Configured Transactional Replication, Merge Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
Experienced in resolving deadlock and blocking issues for concurrent users.
Tuned the SQL queries using SQL profiler and involved in tuning the database.
Client: Presto, Canada Role: Senior Operation SQL DBA Duration: Aug’11–Mar’13
Responsibilities:
Worked as Level 2 analyst and troubleshooting the incidents from the operations perspective.
Provided 24 x 7 Production support for the database and application issues.
Performance tuning on long running T-SQL Queries.
Developed SQL scripts for maintaining administration tasks.
Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables
Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
Created SSIS packages for the extracting, transforming and loading the data from MS Access into SQL Server 2005.
Worked on SQL server Migration from SQL server 2005 to 2008R2
Involved in Generating on-demand and Scheduled Reports for business analysis or management decision using SQL Server Reporting Services
Worked for SSRS for report generation using Excel spreadsheet and also from MS Access.
Worked on moving and restoring the database backups from Prod to Test/Dev/Stage environments for testing activities.
Installed SQL Server2005/2008R2 on Windows 2003/2008R2 Server.
Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.
Scheduling and applying monthly security patches on Production and Non-Production environments.
Experienced in resolving deadlock and blocking issues for concurrent users.
Backup recovery schedules, Backup scripts.
Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
Tuned the SQL queries using SQL profiler. Involved in tuning the database.
Configured Mirroring and monitored the jobs & resolved the Issues.
Client: Microsoft Corporation, Redmond Role: Senior Operation SQL DBA Duration: Jun’08–Aug’11
Responsibilities:
Worked as Level 2 analyst for MBS project for the first 10 months in 3 years and then become an SME and leaded the team of 15 members and mentored the Level1 and Level2 resources in various complex applications.
Involved in installation and configuration of SQL server 2000/2005/2008R2.
Troubleshooting the incidents from the operations perspective.
Analyzing the job logs, event logs, and identifying the problem areas.
Creating and deploying Data Change Requests using Product Studio.
Worked on SQL Server 2005/2008R2.
Writing queries and performing DML operations.
Resolved the issues related to the databases, web servers and process servers.
Scheduling and applying the monthly security patches on production and Pre Productions environments.
Configured Transactional Replication and Monitoring the replication jobs & resolving the issues.
Weekly checking data consistency in the database through DBCC commands.
Monitoring the SQL jobs using monitoring tools such as Site scope.
Working on alerts on production servers and Pre Production servers.
Provided 24 x 7 Production support for the database and application issues.
Worked on various applications which support ERP and CRM products like Axapta, NBE, and other Microsoft ERP applications.
Planned, Defined and Designed database based on business requirement and provided documentation.
Developed various views and stored procedure in order to update the data using another database.
Client: Verinon USA, Chicago Role: Operational SQL DBA Duration: Dec’07–May’08
Responsibilities:
Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs. Responsible for Data Modeling and involved in designing logical and physical data model
Involved in installation and configuration of SQL server 2005/2008R2
Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
Creating and managing schema objects such as Tables, Views, Clusters, Indexes and Maintained Referential Integrity. Developed
Extensively used Joins and sub-queries for complex queries involving multiple tables from different Database. Optimized the database by creating various clustered, non-clustered indexes and indexed views.
Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks. Involved in performance tuning of the slow running queries and stored procedures.
Actively participated in code reviews.
Used to interact with the clients.
Client: CIEFL, Hyderabad Role: Sr. SQL Developer Duration: Jan’07–Nov’07
Responsibilities:
Actively Participated in developing logical model and implementing requirements on SQL Server 2000
Implemented complex conceptual database design into SQL Server 2000 using various Constraint and Triggers.
Implemented complex business requirement in backend using efficient stored procedure and flexible function and facilitated easy implementation to the Front end application. Prepared Reports using MS Access to highlight discrepancies between customer expectations and customer service efforts.
Developed various T-SQL stored procedures/functions for the Application
Involved in SQL Database design and Database objects.
Created Database Objects like Tables, Views, Triggers and indexes using SQL server 2005.
Creating the database and design the table by applying the constraints.
Writing queries and performing DML, DDL operations, stored procedures.
Created the Forms for Data Capturing using ADO.Net Data Objects.
Involved in development of Server side applications using Asp. Net.
Developing Client side programming.
Involved in developing reports using Crystal Reports.
Client: BJJAGB Association Role: SQL Developer Duration: May’05–Dec’06
Responsibilities:
Maintain MS SQL Server 2000/2005 including security, configuration and install service packs upgrades.
MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions
Creating the database and design the table by applying the constraints.
Created Database Objects like Tables, Stored Procedures, Views, Triggers and indexes using SQL server 2005
Perform regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.
Writing queries and performing DML, DDL operations.
Created the Forms for Data Capturing using ADO.Net Data Objects.
Involved in development of Server side applications using Asp. Net.
Involved in Server Side Validation.
Developing Client side programming.
Contact this candidate