We provide IT Staff Augmentation Services!

Sql Server Dba/developer Resume Profile

Troy, MichigaN

Summary:

  • 8 years of experience in Administering and Maintaining the 32bit, 64-bit MS SQL Server in Production, Testing, and Development in both Clustered and Stand alone Server Environment.
  • Experience in installing MS SQL Server 2000, 2005, 2008, 2008R2,2012 and updating with the hot fix and service packs.
  • Implemented Side by Side and In-place Migration of MS SQL Server 2000/2005 to 2008 And Extensively used Database Upgrade Advisor during migration process.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Experience in implementing Disaster Recovery and High Availability concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication Snap Shot and Transactional with Updatable Subscriptions .
  • Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
  • Creating, configuring and managing Always on Availability groups on SQL server 2012.
  • Implemented the new concepts like Data partitioning ,Snap shot Isolation, Database Snapshot, DDL triggers, try-catch blocks, Online indexing, DMV's, DMF's, SQLCMD and dedicated admin connection.
  • Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
  • Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
  • Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans and regularly validating the backups.
  • Configured Security at Active Directory and SQL Server Level by Creating Principals logins and Mapping users to roles Securable and Permissions .
  • Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and System Views and in built Global Variables for the instant analysis.
  • Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Correlated, Non Correlated, and Dynamic SQL queries.
  • Performed BCP, Bulk Insert, Imported and Exported data from different Data Sources.
  • Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
  • Experience in Normalization, Database design, Performance Analysis and Production Support for very large VLDB and Complex Databases.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.

Technical Skills

Project Domain: Application Development, Systems Integration and Database

Administration of MS SQL Server2012/2008R2,2008/ 2005/2000, Oracle,Sybase.

Languages: Visual Basic 6, VB Script, JavaScript, VB.NET, C , C, XML, HTML, XSLT, Web Services.

Database: MS SQL Server2012/ 2008R2/2005/2000/7.0, Oracle 9i/10g, MYSQL, Access.

Web Server: IIS6.0/7.0.

Technologies: Microsoft SharePoint 2007, .NET FRAMEWORK, ASP.NET

Tools: Active X, IIS, SSIS, DTS, MTS, Litespeed, Apexsql, Spotlight, Foglight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, Erwin 4.x/7.x.

ETL Tools: SSIS, SSRS, SSAS.

Business Intelligence: Crystal Reports XI/10/9, Business Objects XI/6.5.1.

Operating System: Windows 2000 Advanced Server,WindowsNT,Windows Server 2003/2008/2012, UNIX, Windows 9x.

Professional Experience:

Confidential

SQL SERVER DBA/Developer

Responsibilities:

  • Implemented Side by Side Migration of MS SQL Server 2000 to 2005/2008/2008R2/2012 on Windows 2003/2008R2/2012.
  • Configured the AWE and /3 GB switch for the 32 bit 2005 server.
  • SQL Server 2005 x64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
  • Applied Patches and Service packs to update different versions of MS SQL Server.
  • Fixed the failed Principals logins , user permissions and security in Active Directory and SQL Server Level.
  • Implemented native Log Shipping and Database Mirroring on MS SQL Server 2005 and 2008R2.
  • Scheduled regular Backup Jobs and kept track of Database by receiving the emails on Alerts.
  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot Isolation, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, DMV's, DMF's, DTA,SQLCMD and dedicated admin connection, Common table Expression CTE .
  • Moved files between the File Groups and partitioned the tables to improve the performance.
  • Utilized the new features of 2008 like CTE, EKM, Transparent Data Encryption TDE , Merge Statement and Compressed Backups.
  • Documented and performed the data base health checks regularly.
  • Created new tables, stored procedures and triggers in T-SQL.
  • Refactored and Fine tuned the queries and Stored procedures in T-Sql.
  • Used native tools like Data Base Tuning Advisor, Profiler and Activity Monitor for performance analysis.
  • Worked with Popular Third Party monitoring solutions like Fog-light.
  • Used SSIS packages to move data from dev to QA and QA to Production.
  • Deployed maintenance plans for regular DBA activities in SSIS.
  • Scheduled night jobs for importing large amount of data using SSIS Packages.
  • Deployed SSIS package for bulk insert and maintained archival data with file system task.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment:SQL Server 2000/2005/2008R2/2012,Windows 2003/2008R2/2012,SSIS,Profiler,Quest Performance Analysis,ASP .NET,Web Services .NET,Control-M, MS Excel, Visual Studio 2008/2010.

Confidential

SQL SERVER DBA/ Developer

Responsibilities:

  • Managed and Administrated Sql Server 2008/2005/2000 highly transitive Production Environment and Active passive clustered environment.
  • Worked to the max database of size 2 TB.
  • Worked With 2008R2 Parallel Data warehouse Edition in handling extremely large amount of data. This is used to spread large tables into over multiple nodes.
  • Expert In 2008R2 Power pivot an end user tool that works in conjunction with share point, Sql Server 2008R2, and Excel 2010 to process large amount of data within Seconds.
  • Extensively worked on 2008R2 Unicode Compression which Reduces the disk space used by the Unicode characters
  • Checking Database Health by using DBCC Commands and DMV'S.
  • Migrated DTS packages to SSIS packages and Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
  • Implementation of Sql Principals, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Configured more than 64 GB RAM on 64 bit Environment.
  • Implemented the new SQL Server 2008 and 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, CTE,CDC, PIVOT, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Handling Memory configurations for SQL Server 2000 and SQL Server 2008 on Windows 2008.
  • Migrated databases from SQL Server 2000 to SQL Server 2008 and documented the process with Pre-Migration and Post-Migration steps.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Recovered the System and User databases from suspect mode.
  • Expert in sizing and utilizing the Temp database in an efficient way.
  • Used log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan.
  • Implemented new topics like CLR integration on Development Server.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Did Performance Tuning of the Stored Procedures.
  • Routine Developer/DBA jobs like Backups and Restores
  • Worked on VMWARE environment and data storage problems resolved.
  • Hands on experience in trouble shooting database issues, Update statistics, database integrity check and Backup operations.
  • Worked extensively with XML data type, indexing, schema processing and integration
  • Monitoring SQL server performance using profiler to find the performance and dead locks.
  • Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005/2008/2008R2 with clustering, Replication,Logshipping,Mirroring, TSQL,Windows2003/2008R2,BugZilla,DTS,SSIS,RedGate,Profiler,SQLSentry,Sharepoint,IBMDB2,TSM,TFS,LiteSpeed,SVN.

Confidential

SQL SERVER DBA/BI Developer

Responsibilities:

  • Administered and maintained SQL SERVER 2008R2/2008/2005/2000 highly transitive Production Environment and Active passive clustered environment.
  • SQL Server 2008 x64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
  • Worked to the max database of size 3 TB.
  • Migrated databases from SQL Server 2000 to SQL Server 2008R2 and documented the process with Pre-Migration and Post-Migration steps.
  • Handling Memory configurations for SQL Server 2005 and SQL Server 2008R2 on Windows 2003 and Windows 2008R2.
  • Extensively worked on 2008R2 Unicode Compression which reduces the disk space used by the Unicode characters.
  • Implemented the new SQL Server 2008 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, CTE, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Implemented Performance Data warehouse for all production servers.
  • Worked with Distributed Partitioned Views DPV for Load balancing between the Servers.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE , PIVOT.
  • Worked on SAN environment and developing reports by using the control center.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Checking Database Health by using DBCC Commands and DMV'S.
  • Migrated DTS packages to SSIS packages and Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
  • Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Recovered the System and User databases from suspect mode.
  • Expert in sizing and utilizing the Temp database in an efficient way.
  • Implemented log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Routine Developer/DBA jobs like Backups and Restores.
  • Worked on call 24/7 production Support on weekly basis.

Environment: SQL Server 2000/2005/2008/2008R2 with clustering, Replication, T-SQL, Windows 2003/2008R2,BugZilla,DTS,SSIS,RedGate,Profiler,SAN,ECC,MOM,SQLSentry,Sharepoint,IBMDB2,TSM,TFS,LiteSpeed,Apexsql.

Confidential

SQL SERVER DBA/Developer

Responsibilities:

  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
  • Worked with Distributed Partitioned Views DPV for Load balancing.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
  • Configured more than 2 GB ram on 32 bit Environment.
  • Migrated DTS packages to SSIS packages.
  • Checking Database Health by SQL SERVER 2005/2000 Production Environment
  • Worked on a database of size 3 TB.
  • Migrated databases from SQL Server 2000 to SQL Server 2005.
  • Worked with SQL Server 2008 new MERGE statement.
  • Worked in Active passive cluster environment.
  • Recovered the System and User databases from suspect mode.
  • Expert in sizing Temp database.
  • Used Log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan.
  • Implemented new topics like CLR integration on Development Server.
  • Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
  • Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows 2003 64-bit, BugZilla, DTS, SSIS, RedGate,Profiler, MOM, SQL Sentry, Share point, Sql Server 2008,Oracle 10g,TFS,LiteSpeed.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Worked on Client/Server tools like SQL Server Management studio 2005 , SQL Server Enterprise Manager 2000 and Query Analyzer to Administer SQL Server.
  • Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
  • Migrated DTS packages into SSIS packages.
  • Handled up to 2 TB Size databases with clustered and stand alone environment
  • Configured Transactional replication on migrated server.
  • Wrote the packages using SSIS in SQL2005.
  • Extensively worked on Dynamic Management Views DMV's and Dynamic Management Functions DMF's .
  • Hands on experience in trouble shooting database issues.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Integrated SQL traces with Performon log to have better graphical analysis to find system bottlenecks.
  • Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
  • Used DTS packages to move logins and jobs from one server to another server.
  • Used log shipping for synchronization of database.
  • Good experience in data modeling and metadata services.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005 VB.NET,C ,WINOWS SERVER 2008,IIS6.0,SSAS.

Confidential

SQL SERVER DEVELOPER

Responsibilities:

  • Worked on migration and maintenance of data using various utilities like DTS, Export, Import and Attach/Detach Data Migration tools.
  • Created maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
  • Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Rebuilding the indexes at regular intervals for better performance.
  • Responsible for Stored Procedures optimization, Performance tuning index tuning.
  • Worked on Fail over Clustering for SQL Server databases for mission critical applications.
  • Provided necessary data validation checks against the data entry.
  • Frequently ran DBCC checks to maintain consistency.
  • Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 7.0/2000, C/C , C , Ms-Access, SQL, Enterprise Manager, Query Analyzer, Windows 2000.

Hire Now