Sql Server dba /developer
Resume:
Mitulkumar Patankar
MS SQL Server DBA/Modeler with Azure
*************.***@*****.***
Professional Summary:
Senior MS SQL Server DBA/Modeler/Developer/Architect with Extensive knowledge in Managing SQL Server environment
Over 9+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2012, 2008 R2, 2005, 2000 and 7.0, in Production, Development, Replication, Azure and PDW Environments
Extensive experience in installation, configuration, and maintenance of MS SQL Server 2016, 2012, 2008 R2/2005/2000, and 7.0
Good experience in Upgrading and migrating from SQL server 2000/2005/2008 R2 to SQL server 2008 R2/2012/2014/2016.
Expert in implementing/installing/configuring and migrating SQL Server to Microsoft Azure based cloud
Expert in upgrading SQL Server environemnts from one data center to Microsoft Azure cloud
Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.
Experienced in Database Backup, Recovery and Disaster Recovery procedures.
Expert in Active/Passive and Active/Active Clustering
Extensive experience in Maintaining High Availability using Always on Availability Groups, Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2016/2014/2012/2008 R2/2005/2000 to provide robust database solutions.
Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
Expert in implementing log shipping and database mirroring.
Experience supporting Microsoft Dynamics CRM software.
Expert in creating backup/recovery Strategies and implementing them. Experienced with Azure, red-gate, commvault, avamar grid and native tools for backup and recovery.
Understanding of HIPPA and NJAC guidelines. Experienced in handling PHI data and PII data using data masking and encryption.
Experience working withTDE databases and Service principal names (Kerberos authentication.)
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
Experienced in writing Windows Power-shell and complex T-SQL scripts to provide faster and better automated solutions.
Experienced with Sql Server Store procedures, SSMS to create and manage objects as well as Troublshooting Methods at server lever and database level.
Participated in continuous improvement efforts in enhancing performance and providing increased functionality.
Experience in Managing Security of SQL Server 2000/05/08/12/14/16 by creating Database Users, Roles and assigning proper permissions according to business requirements.
Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services(SSIS),Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Experience with Reporting Services (SSRS) and Analysis Services (SSAS).
Expert using third party tools from Red-Gate, Idera, SQL Sentry and Solarwinds.
Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
Proficient in troubleshooting database issues.
Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
Team player with Good communication, interpersonal and business analysis skills.
Experienced in working with production 24/7 Environment
Expert working in Virtual Environment using VMWARE for SQL Server
Education/Certifications:
Bachelor Of Science, Gujarat, India
Masters of Business Administrator, Fairleigh Dickinson University, Teaneck, New Jersey
Microsoft AZURE207x Certificate _ Databases in Azure
Microsoft AZURE211x Certificate _ Azure Application Deployment and Management
Microsoft AZURE214x Certificate _ Azure Fundamentals
Microsoft Certified (MCTS)70-432 for Technology Specialist: SQL Server 2008, Implementation and maintenance
Microsoft Certified (MCTS Development)70-433 for Technology Specialist: SQL Server 2008, Database Development
Technical Skills:
Operating Systems: Windows 2012/2008 R2/2008/2003/2000 Server, Linux
Databases: MS SQL Server 10.0/7.0/2000/2005/2008/2012/2014/2016
Languages: T-SQL, PowerShell, PL/SQL, C, C#, VS 2005/08, ASP.net
SQL Server/Oracle Tools: Management Studio, Microsoft Azure, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, Informatica, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), OEM, SQL Loader, Toad, Data Pump Utility
Report Tools: MS Reporting Services, SAS
Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, Double Take replication, Tidal Automation tool.
Database Modeling & Other Tools: IDERA tools, Double Take, Tidal, SQL Compare, SQL Trace
Professional Experience:
ConnectiveRX, Whippany, NJ July 2016 – Feb 2017
Database Administrator
As a leading provider of behavior-based prescription management programs, ConnectiveRX provides event-driven and clinically relevant healthcare messaging through its patented process that improves patient compliance and outcomes, while preserving privacy. This network is made up of e-prescribing, electronic medical record (EMR), and electronic health record (EHR) applications, chain and independent pharmacies, and sponsors of healthcare-related education such as pharmaceutical manufacturers, health plans, payers, and pharmacy benefit managers.
Responsibilities:
Managed Database environment in Development, Intergration, QA, Performance, Production, Azure and PDW environment based on project requirement and company’s best practices.
Expert in SQL Server Installation, configuration and management of 2016/2012/2008R2/2008/2005 servers in Cluster, stand-alone and Disaster recovery environment.
Worked exclusively on Microsoft Azure for cloud based implementation of SQL Server. Worked on Azure SQL server, databases, Sql Data Warehouse.
Set up and Managed Auditing, alerts and monitoring in Azure environment.
Highly skilled in implementating and managing High Availability Environments like Always On Availability Groups, Clustering, Mirroring, Log Shipping and Replication Environment
Worked on Data modeling using ERWin data modeling tool. Experienced in Visual Data modeling, forward and reverse engineering, and model/database synchronization.
Expert in create, manage and documentation of database solutions based on business requirement.
Set up and configured Always on Groups for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting Always on Availability groups environment.
Understanding of HIPPA and NJAC guidelines. Experienced in handling PHI data using data masking and encryption.
Migrated and Upgraded SQL Servers 2008/2012 to 2016 from Windows 2008/2012 servers to new servers using Windows server 2012 and Always-On Availability Groups
Experienced in Capacity planning of very large databases using partitions.
Enforced Cyber Security for databases and involved in documentation to provide risk based solutions.
Experienced in troubleshooting production servers and fixed the user and application issues
Troubleshoot problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
Reconfigured SSIS catalog database and security. Experienced in creating ENV and using dynamic parameters.
Experienced merging data from multiple sources into the data warehouse. Experience in Extraction Transformations and Loading (ETL) tools like Informatica, SQL Server Integration Services(SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Created automated solutions for Backup and recovery for Always on Availability group databases.
Install, setup, configured and tested Red-gate SQL backup software for encrypted backup and recovery solution.
Experienced in setup, configure and managing of SQL Sentry databse performance software. Created alerts for automatic notifications and baselined production database servers.
Worked with Microsoft support to resolve service pack and other issues in the cluster and non-clustered environment.
Experienced in performance enhancement for Data Warehouse processes as well as slow running queries.
Greatly reduced slow running Queries by proper indexing and updating statistics.
Experienced in deploying and managing SSIS packages using Catalog database and its security.
Performed Integration service package migration and reconfiguration, (SSRS) reporting service migration and configuration.
Provided rotational on-call support for the weekends and ongoing projects.
Environment: SQL Server 2016, 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, AZURE, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Red-gate, SQL Sentry, VISIO, Windows Server 2012, 2008 R2, SAN, VMWare, T-SQL.
JP Morgan Chase & Co., Jersey City, NJ June 2015 - June 2016
Advanced Database Analyst
Build Database environment in Development, Intergration, QA, Performance and Production environment based on project requirement and company’s best practices.
Highly skilled in implementating and managing High Availability Environments like Clustering, Mirroring, Log Shipping and Replication Environment.
Expert in create, manage and documentation of database solutions based on business requirement.
Set up and configured Database mirroring for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting mirroring environment.
Experienced in handling large databases up to 5 terabyte in size.
Migrated and Upgraded SQL Servers 2005/2008 to 2012 from Windows 2008 servers to new servers using Windows server 2012 and Always-On Availability Groups
Enforced Cyber Security for databases and involved in documentation to provide risk based solutions.
Experienced in managing PII(Personal Identifiable Informantion) data in all environement.
Worked on Data modeling using ERWin data modeling tool. Experienced in Visual Data modeling, forward and reverse engineering, and model/database synchronization.
Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
Redesigned T-SQL Solutions into Powershell to use more flexibility.
Experienced merging data from multiple sources into the data warehouse. Experience in Extraction Transformations and Loading (ETL) tools like Informatica, SQL Server Integration Services(SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Created automated solutions using T-SQL and Powershell for Backup/Recovery, security, replication of the data etc.
Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.
Development of Automated solutions to decrease manual labor and increase proficiency.
Participated in routine Power-down and Disaster Recovery tests and failovers. Documented and managed lesson learned to make future failover even smoother.
Experienced in performance enhancement for Data Warehouse processes as well as slow running queries.
Greatly reduced slow running Queries by proper indexing and updating statistics.
Experienced in creating and managing backup and recovery solutions using lite-speed, native backups as well as network backups.
Experienced in deploying and managing SSIS packages using Catalog database and its security.
Environment: SQL Server 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Lite-speed, SQL Sentry, VISIO, Windows Server 2012, 2008 R2, SAN, VMWare, T-SQL.
Deutsche Bank, Jersey City, NJ Apr 2015 – June 2015
Senior MS SQL Server DBA
Installed, configured, Managed and supported SQL Server 2005, 2008, 2008 R2, 2012 and 2014 in clustered and non-clustered environments.
Experienced in supporting Global environment with more than 1400 SQL Servers in diff geographical areas such as Germany, USA, China, Japan, South Africa and India.
Highly skilled in managing High Availability Environments like Always On, Clustering, Mirroring, Log Shipping and Replication Environment.
Set up two node and multimode cluster including Always on as new DR solutions with removal of SAN replication between windows servers.
Set up and configured Database mirroring for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting mirroring environment.
Experienced in handling large databases up to 5-10 terabyte in size.
Worked on Data modeling using data modeling tool. Experienced in Visual Data modeling, forward and reverse engineering, and model/database synchronization.
Migrated and Upgraded SQL Servers 2005/2008 to 2012/2014 from Windows 2003 servers to new servers using Windows server 2012.
Enforced Database related security policies and managed security to restrict excessive privileges in production servers.
Experienced in managing PII(Personal Identifiable Informantion) data in all environement.
Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.
Worked with Microsoft support to resolve service pack and other issues in the cluster and non-clustered environment.
Participated in routine Power-down and Disaster Recovery tests and failovers. Documented and managed lesson learned to make future failover even smoother.
Experienced in performance enhancement for Data Warehouse processes as well as slow running queries.
Greatly reduced slow running Queries by proper indexing and updating statistics.
Experienced in creating and managing backup and recovery solutions using lite-speed, native backups as well as network backups.
Install, configured and managed MDS(Master Data Services) and DQS(Data Quality Services)
Experienced in deploying and managing SSIS packages using Catalog database and its security. .
Performed Integration service package migration and reconfiguration, (SSRS) reporting service migration and configuration.
Experienced in following streamline process of Deutsche Bank to handle Production Environment.
Expert in creating, managing and updating documents and transferring knowledge between team members to support large environment.
Provided rotational on-call support for the weekends and ongoing projects.
Environment: SQL Server 2014, 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL
Jennison Associates (Prudential Insurance), New York, NY Nov 2014 – Mar 2015
Senior MS SQL Server DBA
Jennison Associates have carefully expanded their active fundamental equity expertise beyond their flagship large cap growth strategy to include a targeted yet diverse group of investment disciplines that span styles, geographies and market capitalizations. Their fixed income capability includes investment grade active and structured strategies of various durations with both market and customized benchmarks. Jennison's business mix is balanced across institutional and sub advisory channels and includes a small private client component.
Installed, configured and supported SQL Server 2005, 2008, 2008 R2, 2012 in clustered and non-clustered environments.
Handled and Supported Data Center migration Project from NY to NJ.
Carried out best practices and remediation of database servers to increase performance and reduce management overhead.
Installed, configured, test, document and implement SQL Server AlwaysOn Functionality.
Reconfigured Replication, Mirroring, log shipping and clustering during Data Center migration.
Configured and migrated IDERA auditing server with IDERA support.
Install, configure and troubleshoot Double Take (SAN) replication.
Installed and configured Tidal agent for centralize Job management for enterprise solutions.
Created Live Vault backup strategy to have better recovery solutions and less downtime for database servers.
Administered SQL Server’s linked servers to facilitate distributed Queries.
Performed capacity planning and resource allocation for SQL Servers in all the environment
Created databases and database’s objects like tables, views for different SQL Server projects.
Configured, monitored and troubleshoot Failover clustering (Active/Active, Active/Passive)
Developed and tested storage strategies and disaster recovery plans for databases.
Created plans and procedures to migrate mission critical databases to HP Servers.
Upgraded SQL Server 2000 to 2005 and 2008 versions and applied SQL service packs and patches.
Monitored Windows and SQL Server logs to proactively resolve issues.
Set up traces and Profiler to fix performance issues.
Analyzed deadlocks & blocking on the server.
Fixed problems related to memory, CPU, I/O, Disk, etc.
Enforced company’s security policies by creating logins and assigning them proper roles and privileges.
Generated DDLs in ERWIN to create objects in non-prod databases as per project need.
Coordinated change controls for production rollouts.
Experienced in Visual Data modeling, forward and reverse engineering, and model/database synchronization.
Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
Experienced merging data from multiple sources into the data warehouse. Experience in Extraction Transformations and Loading (ETL) tools like Informatica, SQL Server Integration Services(SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Migration of data through DATA PUMP Export- Import from 10 g to 11g R2 RAC database.
Troubleshooting and performance tuning skills for Oracle RAC, ASM and Stand-alone databases.
Properly configured and distributed User DBs and Tempdb files to escalate performance.
Participated in yearly BCE (Business Continuity Exercises) to validate DR strategy.
Provided 24X7 on-call support throughout the project.
Environment: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Linux, Oracle 11g R2, 11g R1, 10g R2, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL
Apollo Management, Purchase, NY Aug 2014 to Nov 2014
Senior MS SQL Server DBA
Apollo Global Management, LLC and its subsidiaries ("Apollo") are leading global alternative investment manager.
Installed, configured and supported SQL Server 2005, 2008, 2008 R2, 2012 in clustered and non-clustered environments.
Handled and Supported Data Center migration Project from NY to NJ.
Carried out best practices and remediation of database servers to increase performance and reduce management overhead.
Installed, configured, test, document and implement SQL Server AlwaysOn Functionality.
Reconfigured Replication, Mirroring, log shipping and clustering during Data Center migration.
Configured and migrated IDERA auditing server with IDERA support.
Install, configure and troubleshoot Double Take (SAN) replication.
Installed and configured Tidal agent for centralize Job management for enterprise solutions.
Created Live Vault backup strategy to have better recovery solutions and less downtime for database servers.
Administered SQL Server’s linked servers to facilitate distributed Queries.
Performed capacity planning and resource allocation for SQL Servers in all the environment
Created databases and database’s objects like tables, views for different SQL Server projects.
Configured, monitored and troubleshoot Failover clustering (Active/Active, Active/Passive)
Developed and tested storage strategies and disaster recovery plans for databases.
Created plans and procedures to migrate mission critical databases to HP Servers.
Upgraded SQL Server 2000 to 2005 and 2008 versions and applied SQL service packs and patches.
Monitored Windows and SQL Server logs to proactively resolve issues.
Set up traces and Profiler to fix performance issues.
Analyzed deadlocks & blocking on the server.
Fixed problems related to memory, CPU, I/O, Disk, etc.
Provided 24X7 on-call support throughout the project.
Environment: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL
Citizens Property Insurance, Tallahassee, FL July 2012 - Aug 2014
MS SQL Server DBA
Working as a Production and Development DBA responsible for SQL Server Database servers in production, development, UAT and QA Environment.
Implemented Always on Availability Groups using SQL Server 2012 to support reporting and high availability requirement.
Created three node active/active/passive clusters with 2008 R2 WSFA for Guidewire Application in Load Test and Production environment to support Policy, Billing, and Claim Center.
Extensively worked on migration project to move all production stand-alone and clustered servers to a new Data Center facility.
Implemented and maintaining Mirroring and log shipping solution on SQL Server 2008 R2 for DR/HA.
Configured, tested, implemented and maintained Transaction replication in development, test and production environment to support Business reporting requirements.
Involved in DR exercise for Virtual servers using EMC’s SRDF (Symmetrix Remote Data Facility) and Physical Clusters using replicated drive system.
Worked on Data modeling using ERWin data modeling tool. Experienced in Visual Data modeling, forward and reverse engineering, and model/database synchronization.
Implemented Merge and Snapshot replication solutions based on Business Requirements.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
Worked on Upgrade project to upgrade SQL 2005/2008 servers to SQL 2012 using in place and side by side for the same server. Backup/restore and EMC replication to upgrade on a different server.
Experienced merging data from multiple sources into the data warehouse. Experience in Extraction Transformations and Loading (ETL) tools like Informatica, SQL Server Integration Services(SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Created the standard documents for Disaster recovery testing and implemented them.
Writing Windows PowerShell scripts to provide faster and better automated solutions.
Environment: MS SQL Server 2012/2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003. Linux, Oracle 11g R2, 11g R1, 10g R2
MetLife, New York, NY Jan 2011 – June 2012
MS SQL Server DBA
MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs. Through its subsidiaries and affiliates, MetLife holds leading market positions in the United States, Japan, Latin America, Asia, Europe, the Middle East and Africa. They are committed to ensuring a future in which they can continue helping people, families and communities around the world get the most out of life.
Roles and Responsibilities:
Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
Interacted with Developers in troubleshooting application and database issues.
Identified, tested and resolved database performance issues to ensure data optimization.
Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
Implementation of system wide security policies and trouble shooting.
Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
Involved in troubleshooting all the performance issues for different database applications.
Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
Documented all the steps and procedures for future references.
Interacted with concern application team in fixing the problems when ever needed.
Created performance baseline reports using RML tool and documented for future use.
Involved in setting up database mirroring for production server
Configured replication methods like snapshot, transactional and merge replications.
Monitoring and scheduled jobs on production and staging environment.
Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
Used the Execution Plan to improve the optimization of the T-SQL code.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Resolving performance related issues to Blocking, Deadlocks and long running queries
Provided 24 x 7 Production support for the database and application issues.
Environment: MS SQL Server 2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.
VERIZON WIRELESS, BASKING RIDGE, NJ Oct 2007 – Dec 2010
MS SQL Server DBA
Description: Verizon Wireless is one of the largest mobile network operators in the United States. According to PC Magazine, the network has 106.3 million subscribers as of 2011, making it the largest wireless service provider in America. Headquartered in Basking Ridge, New Jersey, the company is a joint venture of U.S. telecommunications firm Verizon Communications and British multinational mobile network operator Vodafone, with 55 and 45 percent ownership respectively. On January 9, 2009, Verizon Wireless acquired Alltel Wireless in a deal valued at $28.1 billion. The acquisition expanded Verizon's wireless network.
Roles and Responsibilities:
Upgraded most of SQL Server 2000 to SQL Server 2005
Involved with upgrade of databases from 2000 to 2005 in a Clustered environment.
Worked on SQL Server 2005 with latest Service Packs.
Involved in Performance Tuning on Production, QA and Staging servers of the current project.
Involved in Monitoring Performance of different production servers.
Implemented Database mirroring for disaster recovery.
Maintained various databases for Production and Testing using SQL Server 2005.
Planning the location of data, index, and Transaction log files on the disk.
Performance tuning, and optimization of procedures and queries.
Worked with SQL server Profiler.
Created the backup and restore strategy for production and development environment.
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
Experience in creating and executing SQL Server Integration Services (SSIS) packages.
Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
Experienced merging data from multiple sources into the data warehouse. Experience in Extraction Transformations and Loading (ETL) tools like QL Server Integration Services(SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
Used BCP and Bulk Insert utilities.
Worked with SQL Server Reporting Services (SSRS).
Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, Windows Server 2003, 2000
Contact this candidate