SUMMARY

• Certified Sr. SQL Server DBA with 9 Years and 4 months of experience in MS SQL SERVER 2017/2014/2012 , 2008R2/2008/2005 Database Administration in Production, Test and Development and SIT environment.
• Hands on Experience in Amazon web services Like IAM, EC2, EBS, S3, RDS (SQL Server) Cloud watch and CLI tool.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2019/2017/2016/2014/2012/2008 R 2/2008/2005.
• Expertise & Hands on experience on SQL server migration activities from SQL 2000/ 2005/2008/2008 R2 to SQL 2012/2014/2016/20017.
• Experience in building policies for access control and user profiles using AWS IAM, S3 controls with bucket policies.
• Expertise in Querying RDBMS such as SQL Server and RDS.
• Expertise in DMS activities such as on - premise SQL server to AWS Aurora Postgres and Redshift.
• Expertise in DMS activities such as on- premise Oracle databases to AWS Aurora Postgres and Redshift.
• Expertise in DMS activities such as on- premise PostgreSQL to AWS aurora Postgres and Redshift.
• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.
• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Expert in RDBMS software installation, database server builds, applying patches, applying patches in VM environments (VTM), upgrading, configuring, troubleshooting of SQL SERVER on Windows 2003/08/12/16 servers and Clustered VMware Environments.
• Expertise in new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture.
• Knowledge in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on experience in troubleshoot the tempdb growth and configuration settings.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Backup, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Hands on experience using DMVs and DMFs to finding and solving Performance Issue.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Stored Procedures, Triggers, optimizing code and improving Efficiency.
• Basic knowledge in MongoDB database architecture and Primary components.
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard.
• Worked Extensively on ETL process using SSIS packages.
• Expertise in configure the PerfMon and Extended Events to troubleshoot the performance issues.
• 24/7 on call production support.
• Hands on experience on ITIL process.
• Experience in Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS, DHCP).
• Experience in In-Place upgrade of Windows serves from 2008 R2 to 2016.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Hands on experience on configure the Solarwinds DPA alerts.
• Basic knowledge on SAP ME/MII application.
• Thorough understanding of Windows OS as well as Powershell scripting and Active Directory integrations with SQL Server.
• Expert in raising the Service Requests and keep tracking of requests.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.

TECHNICAL SKILLS

Relational Databases: SQL Server 2019/2017/ 2 / R2/Postgres/Oracle

Database Tools: SSMS, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, DTA, PerfMon, Extended Events, ADO, ADO.NET, Business Intelligence Studio(SSISLanguages C#, XML,HTML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2012, Windows 2008R2, Windows 2003, UNIX. AWS EC2.

Web Servers: IIS 5.0/6.0/7.0, Amazon web services (AWS), Virtual Private Cloud (VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Virtualization: VMWare ESX/ESXi, Amazon AWS/EC2.

Monitoring: Solar winds DPA, App dynamics.

Ticketing Tool: ITSM, Cherwell, Service Center

Cloud Computing: AWS (EC2, ELB, S3), Azure, AWS Elasticache, Cloud Formation, Cloud Watch, CloudTrail, IAM, CloudFront, Glacier, Route53, RDS, DMS.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor. Active Directory, SQL Navigator, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint,, Site Recovery Manager (SRM), SAP ME/MII., Terraform, Ansible

Environment: s: SIT/DEV/QA/Production

PROFESSIONAL EXPERIENCE

Confidential - Bakersfield, CA

SQL server Database Administrator

Responsibilities:

• Understanding the architecture and design of on premise applications before designing and architecting AWS infrastructure for configuring, building and deploying the application.
• Automating the implementation using Ansible scriptsso that the entire application is configured, built.
• Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
• Experienced in creating RDS instances to serve data through servers for responding to requests.
• Created snapshots to take backups of the volumes and also images to store launch configurations of the EC2 instances.
• Written Templates forAWSinfrastructure as a code using Terraform to build staging and production environments.
• Managed Amazon redshift clusters such as launching the cluster by specifying the nodes and performing the data analysis queries.
• Worked on the databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
• Implemented Amazon RDS multi-AZ for automatic failover and high availability at the database tier.
• Created CloudFront distributions to serve content from edge locations to users so as to minimize the load on the frontend servers.
• Worked on migrate the data from on- premise SQL server208R2 and SQL server 2016 to AWS PostgreSQL.
• Analyzed source table designed through Aws Schema Conversion tool and Identified data type issues, fixed the same and created those tables in AWS PostgresQL and Redshift.
• Involved in troubleshoot the DMS task failures and worked on those tasks.
• Worked on Migrate the data from On-primase Oracle databases to AWS Aurora PostgreSQL and Redshift.

Environment: AWS(EC2, VPC, ELB, S3, EBS, RDS, Route53, ELB, Cloud Watch, CloudFormation,AWSAuto Scaling, Lambda, Elastic BeanStalk), SQL, AWSCLI,, Shell scripting,Terraform, Postgresql,Oracle10g.12c, SQL server 2008R2,2016

Confidential, Denver -CO

SQL server Database Administrator Consultant

Responsibilities:

• Installed and configured SQL server 2012/2014 with AlwaysOn 2 replica.
• Working on MS SQL Server 2012/2014 and responsible for installation, configuration and provided 24 X 7 supports to all production Servers.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Responsible for Performing SQL server upgrades, conducting performance analytics, and tuning and system sizing and configuration on SQL server version 2012/2014.
• Monitor SQL instances and logs and take corrective actions if problems arise.
• Maintaining the database consistency with DBCC at regular intervals.
• Responsible for Identify problematic tables and prepare Implementation plan for cleanup the tables.
• Created database tables based on SAP MII application functionally.
• Created user defined stored procedures to run multiple transactions in limited duration on SAP MII application.
• Worked on design triggers for automatic executions after user committed transactions.
• Created User defined functions based on SAP MII application requirement.
• Created Views and Synonyms to collect the sales data for Reporting Purposes.
• Configured SQL JDBC connections between database servers and SAP MII application servers.
• Worked on Import the application required data to databases from SAP MII application binary file systems.
• Work on database development activities on Development environment and subsequently make changes on Quality and Production environments.
• Worked on ITIL process to implement the make database changes on each environment (I,e Development, QA and Production environment).
• Work on provide the SQL database accesses to respective stakeholders and share the credentials in encrypted format.
• Developed and Rewrote T-SQL queries for better performance.
• Worked on Security issues dealing related to logins, DB users, and application roles and linked Servers.
• Configured the automatic database maintenance jobs for continuous monitoring.
• Monitor the database server’s performance through performance counters and SQL Native tools.
• Analyzed long running queries and create the indexes and recommend for query tuning.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Involved is setting up maintenance jobs related to SQL server health checks and Application health checks.
• Work on query analysis and ensure locking and blocking should not occur during parallel process.
• Analysis the SQL query execution plan and duration and if any significant changes find the root cause and resolve the issue.
• Capture column fragmentations and work on for column defragmentation.
• Develop auto rebuild, re-organize and update statistic maintenance jobs for column defragmentation.
• Actively worked on review and monitor SQL servers and Instance resources to insure continuous database operations (I.e, database storage, memory, CPU, network usage and I/O contention).
• Involved in all Deployment phases (I,e D1,D2A,D2B and D3) to streamline the plants are in-line with SAP MII application requirements.
• Work on make changes on SQL database objects (I,e tables, Stored procedures, functions) per application requirements on Development environment and subsequently move to Quality environment.
• Developed and maintained variouscomplex T-SQL, Powershell scriptsfor various DBA related tasks.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Actively worked on test the required changes on QA environment and move same changes to Production environment.
• Work on establish the connectivity with database server and SAP MII application.
• Work on troubleshoot the production issues and find out the root cause analysis.
• Perform the database development activities in tables, stored procedures and functions during cutover and application maintenance window in each deployment phase servers as required.
• Create SQL server instances on SQL server 2014 version and databases with appropriate initialization parameters and database structures.
• Check for the database maintenance failed jobs, investigate the route cause analysis and resolve the issue.
• Implemented and provided the design plans for the new SQL Server 2014 concepts like New In-Memory OLTP Engine, Enhancements to Backups and Buffer pool extension.
• Co-ordinate with respective stakeholders and SAP MII application team and identify the records with respective column key parameters within the respective table (I,e Delta changes) between each Deployment phase.
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Compare and Identify delta changes on during each deployment.
• Work on import the same delta changes on required databases.
• Work on identify and cleanup the data that not require further after discuss with SAP MII application team for better performance.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Worked on troubleshooting critical performance, space, availability and various issues using TSQL/Powershell.
• Plan coordinate and implement security measures safeguard production and sales order data against to unauthorized users.
• Support to SAP Basis administrator team while configures the SAP MII application for providing database level input parameters.
• Read the ERD diagrams and understand on primary key and foreign key relationship and column relationship between the tables.
• Troubleshoot the issues on configure the SAP application with respective database level.
• Work on Third party application vendors to understand the application functionality and provide recommendations and feedback to Leadership team.
• Attend troubleshoot calls and resolve the issues during Hypercare.
• Support responsiveness to outages and issues.
• Collaborates with developers/application designers in solving critical defects of application before release dates.
• Developed a .bat file to shrink the log file after successful log backup file job completed on Cummvalut.
• Excellent communication skills, both written and verbal are required for this position.
• Perform other tasks and duties as assigned by supervisor.
• Monitor the day to day transactions from Solarwinds DPA and Identify T-SQL long running queries.
• Installed application on AWS EC2 instances and configured the storage on S3 buckets.
• Amazon IAM was used to maintain the user credentials and also involved in creating custom IAM policies to various groups defined within the organization.
• Created SQL native backup jobs in AWS IaaS environment servers.
• Scaled distributed in-memory cache environment in the cloud using Elastic cache.
• Configured and scheduled the scripts to automate the module installation in the environment.

Environment: SQL Server 2005/2008R 2/2012/2016/2017/2019 , T-SQL, Windows Server and SAP Manufacturing Integration and Intelligence, AWS, Cloud Watch, S3, EBS, EC2, RDS, DMS, EC2, Cummvalut, Microsoft Azure and SQL Azure.

Confidential, Cranston- RI

SQL Server Database Administrator

Responsibilities:

• Installation, configuration and upgradation of SQL server 2012, SQL servers 2014 and SQL server 2016 on Windows 2008 and Windows 2012 based on Enterprise Distributed Security (EDS- IBM) standards.
• Installed and configured SQL Server 2016 and higher versions. Configurations built and supported should include scenarios that include leveraging SQL AlwaysOn and Windows failover clustering
• Upgraded/migrated the several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
• Prepared the documentation and implemented the Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Involved Disaster Recovery excise and got CREDO awarded.
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Implemented best practices for system and data administration functions for complex, multi-system, multi-platform network on Windows, UNIX and Linux based platforms.
• Migrating the Database from SQL server 2000 to SQL server2008 and from SQL server 2008 to SQL server 2012/SQL server2014 on SIT/DEV/QA/PRODUCTION region.
• Migrated the DTS packages from SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination.
• Configuring of SQL Server 2014 new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
• Used multitask data pump in DTS/ETL.
• Assist with database transaction and security audits.
• Troubleshoot and problem solving of SQL related issues, including advising on customer issues.
• Reviewed T-SQL code and maintaining coding standards in all SQL Server environments.
• Hands on configuring Tempdb with considerable Memory and Raid Levels for better performance.
• Creating and Maintaining Trace Audits for Security events.
• Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Created and Modified existing functions and procedures based on business requirements.
• Setting up Connection Strings and connecting SQL Server Databases from application front.
• Configured SSIS and SSRS packages on sql server 2014 and moved the packages and tested them.
• Involved on application migration activities from windows 2003 to windows 2012.
• Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service on Azure environment as a part of SQL server 2014 and SQL server 2016.
• Provided support on .net\java application migration activities on Windows 2012R2 operating systems.
• Provided 24*7 on call support.

Environment: SQL Server 2005/2008R 2/2012/2014/2016 , T-SQL, Windows Server, HTML 4.0, JavaScript, Access, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), DB2, Microsoft Azure and SQL Azure

Confidential

SQL Database Administrator

Responsibilities:

• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Managed the database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Worked on moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Installed and configured MySQL on Linux and Windows environments.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1.
• Implemented SQL Server high availability solutions includingclustering, Always-on replication, log shipping and Symmetric Remote Data Facility (SRDF).
• Worked inActive/Passive and Active/Active clusterenvironment.
• Responsible for installations, upgrades, patches and fixes.
• ExportandImportof data from text files and Excel to SQL Server database usingBulk Copy InsertandBCP utility
• Setup profiler traces for slow running queries and used query execution plan to optimize the performance and improve I/O utilization.
• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring andRAIDtechnology.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
• Monitored performance and current space utilization reports to management along with recommendations for any corrective action.
• Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler
• Monitored performance and current space utilization reports to management along with recommendations for any corrective action.
• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Responsible for migration of databases from one version to other versions and applying patches.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.

Environment: Windows Server 2008R2/2012R2, HTML 4.0, JavaScript, Access, Microsoft Azure and SQL Azure. SQL Server 2005/2008/2008 R2/, T-SQL

Confidential

Database Engineer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Heavily involved in migrating all in houseSQLserver instances & databases toSQLAzurecloud platforms.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• Configured SSRS & SSIS for SQL Server 2008 R2, SQL server 2012.
• ImplementedTransactional Replicationfor New Production Environments
• Creating and Troubleshooting SSIS Packages in SQL Server 2012.
• Worked on upgrading DTS to SSIS on SQL server 2012.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers (CMS), Transparent Data Encryption (TDE), Table and Page level compression and Resource Governor.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Implemented and Maintained Log Shipping, Database Clustering, Mirroring, AlwaysOn HADR.
• Have developed TSQL code to setup Multi server Agent jobs to monitor CPU Utilization, Long running Jobs, Failed Jobs, Long running SQL Processes, Number of suspended sessions, Number of active sessions, Blocked sessions, availability group status check, replication monitoring, windows pending reboot, windows SQL Patch check and some other best parameters.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database Links and formatted the results into reports and kept logs.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application & database performance using SQL Profiler, Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Implemented backup and retention strategies based on business policies.
• Performed Backup/Restore by using VERITAS Net Backup.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Improved performance of slow running queries using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: Windows NT/ 2000/2003/2008 R2,SQL Server 2005/2008/2008 R2/2012,T-SQL,VERITAS.

Confidential

Trainee SQL DBA

Responsibilities:

• Installed SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 with latest service pack and hot fixes and documented the same.
• Upgraded and migrated the servers from SQL Server 2000 to SQL Server 2005/2008.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages and resolved issues during migration.
• Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Implementing high availability using Replication, Log shipping and mirroring technologies
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations.
• Install, Configure and deploy SSIS, SSRS and SSAS.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports.
• Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views (DMV).
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data.
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database Links and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: .NET Framework 3.5, Visual Studio 2008,C#.net,ASP.Net,Web Services, SQL Server 2005/2008/2008 R2.