• Manage and maintain SQL Server DB for application and data warehouse across Development, Test, and Production environment.
• Analyse, plan, and implement database backup/recovery, High Availability/Performance configuration, archival.
• Support service requests on database and access provisioning.
• Analyse, plan, test and coordinate with Database team in database server patches and upgrade.
• Analyse, test and coordinate with Database team in database server OS patches and upgrade.
• Support, track, and coordinate Database Change Request from application and report team.
• Provide technical advice/solution to application and report team on application and report database.
• Provide technical advice/solution and support the conduct of performance tuning.
• Provide technical advice/solution to ETL team considering impact to database performance and availability.
• Provide technical advice/perform data modelling, index and partition planning for Data Warehouse and potentially OLTP databases.
• Support application/report team on troubleshooting of issues, tracing, and data lineage.
• Will be advantageous to have skills on data sync/integration between on premise SQL Server to Azure SQL Server Databases cross continent.
• Will be advantageous to have skillset to develop, troubleshoot and operationalized SSIS packages to support adhoc requests on data porting activities.
------------------------------------------------------------------------------------------------------------------------------
7+
years of experience in Database Administration for very large and complex
databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
Experience
in manage and maintain SQL Server DB for application across Development,
Test, and Production environment.
Expertise
in Database Administration on Production Servers.
Experience
in planning and implementing database backup/recovery, High Availability
and Archival.
Experience
in Database server patches and upgrade.
Performing
index creation, index management and partition planning for databases.
Experience
with SSIS packages for data porting activities.
Strong
technical background along with the ability to perform business analysis
and write effective documentation and specifications.
Experience
in T-SQL writing stored procedures, triggers and functions.
Administering
SQL Server High Availability and Disaster Recovery strategies.
Experience
in DTS, Bulk Loads with SSIS and BULK INSERT ETL operations.
Worked
on Clustering, Troubleshooting production issues and raising high
availability.
Experience
in Disaster Recovery Planning and Security Management operations.
Proficient
in SQL Server Replication, Backup/Recovery, Disaster recovery and
planning.
Handled
multiple SQL Instances on Cluster environment for Server Consolidation
projects.
Troubleshoot
performance problems, fine-tuning of databases and index Analysis.
Worked
on SQL Server 2012 migration from SQL Server 2008 / 2005.
Having
Experience on Data center servers and handling TB sized databases.
Experience
in supporting Very Large databases (VLDB) and troubleshooting the
problems.
Strong
experience in mentoring team members and writing documentation.
24
X 7 Production Database on Call Support
------------------------------------------------------------------------------------------------
Database administration and Database
Programming.
Worked on Control-M for creating and
monitoring jobs for Data load, Data process and Data sync and alert.
Worked on QCs related with DB changes as
issues / bugs raised by users.
Worked on root cause analyzing for various
data discrepancy issues raised by users and provided solutions for the
issues.
Worked on analyzing the SQL Server DB size and
growth for deciding the storage requirements.
Planning for rebuilding / monitoring the
indexes at regular intervals for better performance.
Planning for Recovery of databases from backup
in disasters.
Creating and maintaining day to day documentation.
Responsible for monitoring and making
recommendations for performance improvement in hosted databases.
This
involved index creation, index removal, index modification, file group
modifications, and adding scheduled jobs to re-index and update statistics
in databases.
Knowledge Transfer to the team members.
-----------------------------------------------------------------------------------------------------
Migrated SQL server 2008, 2008 R2 to SQL
Server 2012.
Administered clusters Active/Passive on SAN
environment.
Worked on SQL Server Integration Services
(SSIS)
Using DMVs, Performance dash board, Mirroring,
database snapshots.
Rebuilding / monitoring the indexes at regular
intervals for better performance.
Recovering the databases from backup in
disasters. Implementing Point-In-Time Recovery solutions.
Involved in trouble shooting and fine-tuning
of databases for its performance and concurrency.
Involved in Source Data Analysis, analysis and
designing mappings for data extraction.
Responsible for Design and Development of SSIS
Packages to load the Data from various Databases and Files.
§
Monitoring and handling the tickets in tools like
Magic.
Used SQL Server Profiler, SQL Server Agent,
and Database Engine Tuning Advisor (DTA).
Expert in implementing the snapshot isolation
and DDL triggers.
Responsible for monitoring and making
recommendations for performance improvement in hosted databases.
This
involved index creation, index removal, index modification, file group
modifications, and adding scheduled jobs to re-index and update statistics
in databases.
Implemented Data partitioning for large size
tables.
Performed installation of service packs for
SQL Servers.
§ Monitoring the SQL drive space and ensuring enough
space is available for DBs to grow.
Creating Logins and granting Permissions,
and Mapping user databases as per the client’s requirements.
Providing 24x7 based support for clients being
on calls.
---------------------------------------------------------------------
Database Administration, Database Programming.
Restructuring the stored procedure, designing,
coding and developing the same using the T-SQL Programming.
Extensively worked on Dynamic Management Views
in SQL Server 2005.
Managed the migration of SQL Server 2005
databases to SQL Server 2008.
Monitoring SQL server performance using SQL
Profiler to find performance hindering.
Performed daily tasks including backup and
restore by using SQL Server 2005 tools like SQL Server Management Studio,
SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
Rebuilding the indexes at regular intervals
for better performance.
Monitored and modified Performance using
execution plans and Index tuning.
Archiving the data in regular interval and
automated the process for DB size management.
Extensively worked on DBCC commands and
Dynamic Management Objects.
Involved in trouble shooting and fine-tuning
of databases for its performance and concurrency.
Complete documentation about the database.
Recovering the databases from backup in disasters.
Export or Import data from other data sources
like flat files using Import/Export through SSIS.
To analyze long running slow queries and tune
the same to optimize application and system performance.
To set up SQL Server configuration settings
for better server management.
Providing 24x7 based support for clients being
on calls.
§ Monitoring the SQL drive space and ensuring enough
space is available for DBs to grow.
Importing and exporting data from and to SQL
Server using SSIS.
Creating Logins and granting Permissions,
and Mapping user databases as per the client’s requirements.
Setting up Database mail by creating
operators and DB mail profile. Creating alerts like SQL Server services
restart.
------------------------------------------------------------------------------------------
Database Administration, Database Programming.
Restructuring the stored procedure, designing,
coding and developing the same using the T-SQL Programming.
Extensively worked on Dynamic Management Views
in SQL Server 2005.
Managed the migration of SQL Server 2005
databases to SQL Server 2008.
Monitoring SQL server performance using SQL
Profiler to find performance hindering.
Performed daily tasks including backup and
restore by using SQL Server 2005 tools like SQL Server Management Studio,
SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
Rebuilding the indexes at regular intervals
for better performance.
Monitored and modified Performance using
execution plans and Index tuning.
Archiving the data in regular interval and
automated the process for DB size management.
Extensively worked on DBCC commands and
Dynamic Management Objects.
Involved in trouble shooting and fine-tuning
of databases for its performance and concurrency.
Complete documentation about the database.
Recovering the databases from backup in disasters.
Export or Import data from other data sources
like flat files using Import/Export through SSIS.
To analyze long running slow queries and tune
the same to optimize application and system performance.
To set up SQL Server configuration settings
for better server management.
Providing 24x7 based support for clients being
on calls.
§ Monitoring the SQL drive space and ensuring enough
space is available for DBs to grow.
Importing and exporting data from and to SQL
Server using SSIS.
Creating Logins and granting Permissions,
and Mapping user databases as per the client’s requirements.
Setting up Database mail by creating
operators and DB mail profile.
Creating alerts like SQL Server services
restart.
-----------------------------------------------------------
Database Administration and monitoring.
Migration of SQL Server 2000 databases to SQL
Server 2005.
Troubleshooting problem in MS SQL Server
environments and providing support to users.
Performed daily tasks including backup and
restore by using SQL Server 2005 tools like SQL Server Management Studio,
SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Prepared the project management and technical
documentation.
Monitored and modified Performance using
execution plans and Index tuning.
Rebuilding the indexes at regular intervals
for better performance.
Using and Managing the TSM backups.
Worked on DBCC commands and Dynamic Management
Objects.
Complete documentation about the database.
Recovering the databases from backup in disasters.
To set up SQL Server configuration settings
for better server management.
Monitoring and handling the tickets in tools like
ManageNowR2.
Providing 24x7 based support for clients being
on calls.
Experience in ITIL activities like Incident Management,
Problem Management and Change Management processes.
Creating and maintaining day to day documentation
Involved in Due Diligence prior to the project
transition and participated in Business specific KT.
Onsite experience in project transition to
India.
-----------------------------------------------------------------------------
Database Administration, Database Programming.
Implementation of SQL Logins, Roles and
Authentication Modes as a part of Security Policies for various categories
of users.
Rebuilding the indexes at regular intervals
for better performance
Designed and implemented comprehensive Backup
plan and disaster recovery strategies Implemented.
Involved in trouble shooting and fine-tuning
of databases for its performance and concurrency.
Monitored and modified Performance using
execution plans and Index tuning.
Rebuilding the indexes at regular intervals
for better performance.
Perform SQL Server service pack upgrades.
Extensively worked on Enterprise Manager for
managing the database.
Troubleshoot performance problems and
fine-tuning of databases.
Involved in Index Analysis and Performance
Tuning.
Converting DTS packages into SQL Server 2005
Integration Services.
Migrating SQL Server 2000 data bases into SQL
Server 2005.
Recovering the databases from backup in
disasters.
To analyze long running slow queries and tune
the same to optimize application and system performance.
No comments:
Post a Comment