Ms Sql Server Dba Resume
4.00/5 (Submit Your Rating)
Harrisburg, PA
SUMMARY
- Professional wif 7 Years of IT experience in Microsoft Database Technologies wif various Industries like Health care and Insurance as aSQL Server DBAin MSSQLSERVER 2014/2012/2008 R2/2005 Database Administration DBA
- Experience in installing, configuring, managing, monitoring and troubleshootingSQLServer 2000/ 2005/2008/2008 R2/2012 in stand - alone and clustered environments.
- Used SQL Loader extensively to extract data from flat files and loading into teh new application.
- Involved in Technical decisions for Business requirement, Interaction wif Business Analysts, Client team, Development team, Capacity planning.
- Experience in database Migration, Backup, Restore and Recovery procedures.
- Strong experience and outstanding knowledge of high availabilityServer solutions, including Log Shipping, Database Mirroring, Replication (Transactional and Snapshot) andSQLServer Active/Active and Active/Passive Failover Clustering, Always On.
- Experience in migration from MSSQLServer 2005 to MSSQLServer 2008 R2 and MSSQLServer 2008 R2 to MSSQLServer 2012/2014.
- Working knowledge of patching teh servers wif Latest security patches and service packs.
- Experience in creating Database maintenance Plans, jobs, schedules, alerts and operators.
- Experience in managing security at database and server level and database level permissions.
- Experience in using Performance Monitoring using tools such as Perf Mon, Spotlight.
- Experience in using third-party tools such as Remedy 4, Remedy 7.
- Experience in Monitoring data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
- Extensive knowledge in TuningSQLqueries & improving teh performance of teh Database.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
- Handling Memory configurations for SQLServer 2012.
- Extensive experience wifSQLServer and T-SQLin constructing triggers, tables, user functions, stored procedures, views, indexes, user profiles, relational database models.
- Experience in resolving blocking and dead lock issues by usingSQLcommands.
- Experience in installing, configuring and administration of Oracle 11g/10g environment.
- Experience in creating, testing, deploying and securing DTS and SSIS Packages.
- Experience in migration of Data from Excel, Flat file, Oracle to MSSQLServer by using Bulk copy Program (BCP), Data Transformation Services (DTS) andSQL Server integration Services (SSIS)
- Experience wif reporting writing on SSRS( SQL Server Reporting Service)
PROFESSIONAL EXPERIENCE
Confidential, Harrisburg, PA
MS SQL Server DBA
Responsibilities:
- Perform and/or coordinate DBA activities on multiple SQL Servers 2008 and 2012
- Monitor performance, capacity, service levels, and error logs.
- Worked wif teh project lead on a migration project to transfer teh system from CISCO ICM to CISCO UCCE.
- Installed, configured and maintainedSQLServer 2008R2/2012/2014 and applied hot fixes, cumulative updates and service packs.
- Installed and administered Two-Node Cluster Configuration (Active/Active and Active/Passive) inSQLServer 2008R2/2012 on Microsoft Windows Server 2012.
- Upgrade databases fromSQLServer 2005 toSQLserver 2008 R 2/ 2012/ 2014.
- Provided High availability through Clustering (Active/Active and Active/Passive), Mirroring, Log Shipping, Replication (Transactional), and Always On.
- Involve in Capacity planning for new and existing applications.
- Used Microsoft Migration Assistant using (SSMA) to connect to Sybase servers and migrate teh data to new createdSQLServer databases.
- Understanding Business High-Availability needs and Implementing Backup and Recovery Procedures.
- Security Administration by creating user logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granted privileges to users and groups.
- Production Code Deployment and handling concurrent user requests.
- Maintain integrity and consistency of teh databases.
- Experience in Performance tuning Long Running Reporting Queries by analyzing query plans.
- TroubleshootingSQLServer locking, blocking and deadlocking usingSQLProfiler.
- Promptly identified and solved performance bottlenecks for memory, I/O and Disk Rebuilding / monitoring teh indexes at regular intervals for better performance. Scheduling, Migrating, Deploying and Troubleshooting SSIS Packages.
- Worked extensively wif SSIS to Import, Export and Transform teh data between teh servers Create, Deploy and Manage Standard Business Reports using SSRS.
- Automated Administrative tasks using Power shell and T-SQL.
Environment: MS SQL Server 2008-R2/2005/2012, SQL Server Integration Services, SQL Server Reporting Services.
Confidential, Plantation, FL
MS SQL DBA
Responsibilities:
- Installed, configured and maintainedSQLserver 2005/2008/2008 R2/2012 and applied hot fixes, cumulative updates and service packs.
- Installed and administered Two-Node Cluster Configuration (Active/Active and Active/Passive) inSQLServer 2008R2.
- Upgrade databases fromSQL Server 2008 R2 toSQLserver 2012.
- Implemented teh newSQLServer 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
- Installed, configured and troubleshootSQL2012 Always on High Availability in between teh data centers and participated in DR test.
- Implemented, configured and troubleshooting Snapshot and Transactional Replication Experience in troubleshooting mirroring, log shipping.
- Rebuilding/Monitoring teh indexes at regular intervals for better performance.
- Performing database checks and maintaining teh database health.
- Created, customized and Maintained CDCs.
- Extensively Designed developed and maintained SSIS packages and ETL processing using Visual Studio..
- Maintaining monthly scheduled Data load, Data refresh activities.
- Identify and troubleshoot slow running query in improving performance.
- Creating Data source, testing and deploying reports in SSRS environment.
- Deployed/Managed SSIS packages by using Integration Services Catalog inSQL2012.
- Support and troubleshoot existing SSIS package.
- Compared and Synchronized Database Schemas and Data by using Visual Studio 2010/2012.
- Working along wif teh developers to perform database development activities.
- Using PowerShell for day to day Administration ofSQLServers.
- Provided guidance to teh development team on writing stored procedures and implemented teh standards, guidelines and best practices for database development.
- Maintained documentation for all servers and database releases/activities/Disaster Recovery Plan.
Environment: Windows 2003/2008 R2,Server, SSIS, SSRS,SQL Profiler, Visual studio 2010/2012, TFS, SCOM, Red Gate and Idera tools.
Confidential, South Birmingham, AL
SQL Server DBA
Responsibilities:
- Provided 24x7 technical supports for mission critical Production Databases supporting HP data centers.
- Responsible for configuration, maintaining and troubleshooting and administration ofSQLServer 2005/2008/2008 R2 on dedicated and shared environments.
- InstalledSQLServer 2008R2 in cluster environment, added/managed nodes toSQLServer in Windows Cluster environment.
- Performed Capacity Planning onSQLSERVER 2008 & 2012 to estimate teh size of database.
- Configured and troubleshooting Log Shipping and mirroring and Replications.
- Performed Side-by-Side upgrade from SQL SERVER 2008/2008R2 to SQL SERVER 2012
- Installation of Service Packs. Applying Hot Fixes.
- Handling backup process, writing teh automated jobs for taking teh weekly full backup, daily Differential backups and hourly transactional backups
- Responsible for maintaining and troubleshooting all teh servers which includes Agent Jobs,
- Maintenance plans, connectivity issues and fragmentation issues.
- Created and Maintained Users, roles, groups and granting teh privileges to users and Groups and maintaining security up to date.
- Handling Change Request, Building BCP Environments, performing Real-time Failover Testing.
- Ensuring Integrity and Consistency of teh databases for optimal performance using DBCC Commands.
- Used SQLProfiler for troubleshooting, monitoring, optimization of SQL SERVER.
- Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
- Performed routineSQLServer database health check-up and ensured 100% availability of all production databases.
- Worked on designing packages, deploying packages and Package security and Scheduling SSIS Jobs.
- Designed SSIS packages to load data in toSQLSERVER destination tables from ORACLE sources.
- Worked on Troubleshooting SSIS packages.
- Developed Incremental data logic to load data into theSQLServer using SSIS from Oracle databases.
Environment: SQLServer 2005/2008/2008 R2 Enterprise Edition,SQLServer Integration Services (SSIS), Windows Server 2003/2008/2008 R2, Power shell1.1,SQLProfiler, Perfmon, Fog light, Spotlight 6.0, LiteSpeed 6.0, Excel.
Confidential
Junior Oracle Dba/Sql Dba
Responsibilities:
- Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
- Database managing and monitoring usingOracleEnterprise Manager (OEM).
- Performed user administration, space administration on development and test database.
- Creating teh database, tables, table spaces and data objects, setting privileges, indexes, user and password management, Security administration.
- Creating Indexes, rebuilding indexes, analyzing indexes to improve teh performance of query.
- Responsible for creating teh tables, views, stored procedures, triggers.
- Participated in creating indexes to improve teh performance of database.
- Created Constraints, Defaults and Views.
- Active part in performance tuning and query optimization.
- Generated reports using Crystal reports.
- Used Data transformation Services (DTS) to export and import data.
- Assisted in taking database backup and restore.
- Used SQL server profiler to troubleshoot teh problems.
- Involved in creating users and assigning permissions to access teh database.
