We provide IT Staff Augmentation Services!

Sql Dba /service Engineer Resume Profile

Bellevue, WA

SUMMARY:

  • Seven plus years of IT experience this includes Microsoft Database Technologies with various Industry verticals like Advertising, Financials, Transportation, Insurance, Banking and Health Care.
  • Extensive knowledge of Relational Database Management Systems RDBMS .
  • Good understanding in implementing different types of SQL Server Report Server environments and configuration with SharePoint, SCOM, MOM TFS.
  • Expert in implementing Transactional Replication which includes advanced tuning of Transactional replication.
  • Experience with Database Backup, Recovery and Disaster recovery procedures.
  • Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, Database Consistency Checks using DBCC.
  • Experience working with Window 2008 Enterprise Server, SQL Azure cloud and Windows 2012 Advanced Server Administration and Installation.
  • Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters.
  • Implemented log shipping with SQL Server 2008 and SQL Server 2008 2012.
  • Experience in working high transacted OLTP OLAP systems.
  • Expert in Configuring, Managing and optimizing transactional replication in OLTP environments.
  • Excellent knowledge in RAID 0,1-5
  • Good experience with MSSQL Azure/Cloud technologies and PowerShell.
  • Experience in Extracting, Transforming and Loading ETL data using DTS Import/Export utility, BCP and DTS Packages.
  • Good experience on load balancers and networking technologies.
  • Developed backup and recovery strategies for SQL Server databases.
  • Documented disaster recovery plans and participated disaster recovery drills.
  • Experience in installing Service Packs for SQL Server and OS.
  • Experience in contacting Microsoft PSS and other vendors for product and technical support.
  • Experience working with Window 2008 Enterprise Server and Windows 2012 Advanced Server Administration and Installation.
  • Good experience on Oracle, Sybase and PLSQL
  • Good Experience in Data extraction using the Microsoft DTS, SSIS
  • Experience in monitoring the disk usage and the memory usage of the servers
  • Excellent team player with good communication skills.
  • Good team player with strong analytical skills.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

SQL SERVER SKILLS:

SQL Server 7.0/2005/2012/2014

SQL Server Administration

SQL Server 2005

Log shipping

SQL server 2008/2012/2014

SSRS Configuration SharePoint Integration

All types of Replication

Stored Procedure

Database Maintenance

Import, Export, DTS

Communication Technical Knowledge

Creating Jobs and Alerts

Performance Tuning

Clustering, DMV, powershell

SSIS IIS Administration for SSRS

SSRS integration with MS tools like MS CRM.

SQL Server Upgradation Advisor

Database Mirroring 2008, Always on

TECHNICAL SKILLS:

  • RDBMS MS SQL Server 2008R2, 2005, 7.0
  • Developer Tools Visual Studio 2005 2008 Report Designer, IIS Administration for SSRS.
  • Modeling Tool ERWIN 3.x, Visio 2002
  • Operating Systems Windows 2008, 2003 Enterprise Server, 2000 Advanced Server, Windows NT
  • Other Tools SQL LiteSpeed, IDERA SQL Diagnostic Manager , RAID and storage systems like NetApp Systems.

APPLICATION AREAS:

  • Setting up and configuring Reporting Services in native mode and other integration modes with SharePoint, MS CRM, SCOM, MOM TFS etc.
  • Setting up Log Shipping using DTS Data Transformation Service
  • Administration and Installing of MS SQL Server 2008, 2005, 2000, 7.0
  • Configuring Cluster Server
  • Report Design using Visual Studio 2005 2008.
  • Managing instances on cluster server
  • Troubleshooting and Performance tuning.

PROFESSIONAL EXPERIENCE:

Confidential

Role: SQL DBA /Service Engineer

Responsibilities:

  • Responsible for setting up, configuring and maintaining the BizTalk server farms on the Test, UAT and PROD environment, including setting up Applications, Orchestration, Send/Receive locations.
  • SQL Server 2005, 2008 and 2012 Performance tuning and replication for high availability on UAT and Production environment.
  • Configure various Windows 2003/2008/2012/SQL Azure clustered and non-clustered environments to provide high availability and reliability web sites and applications.
  • Configured and Maintained Transactional Replication by initializing subscription with database backup on a 4TB database.
  • Launched the Xbox one application related royalty date in the Azure/Hadoop environment.
  • Implemented the log shipping, mirroring and replication as part of the DR Activity and high availability and working experience on Always On.
  • Configured Database Mirroring on a 4TB database for High Availability in case of a Disaster.
  • Configured Log shipping on multiple databases for Disaster Recovery and configured DB Mail automation for alerting.
  • Driven the project responsibilities with the ITIL/MOF.
  • Written the PowerShell automation scripts for the database and server level tasks.
  • Supported the system 24 7 as part of the on call rotation.
  • Used SQL Dashboard reports and DMV's for performance analysis.
  • Install and Configure SSL Certificates to ensure security of the websites deployed on IIS6.0/7.0.
  • Responsible as the Subject Matter Expert for production environment and application s .
  • Available for on call escalations and advanced break fix problems and problem management.
  • Facilitates and coordinates release management process and adherence to it.
  • Participates in major problem reviews, initiates requests for change and ensures compliance with operational and security policies
  • Lead incident management team in trouble shooting issues and can identified potential problems in applications and advocate for solutions.

Environment: SQL Server 2008 Enterprise Edition R2, OLTP OLAP, SQL 2008/2012/2014, Azure, Services 2000/2005, Windows 2000 Advanced Server, Windows 2008 Enterprise Edition, Idera, Lite speed, ITIL

Role: SQL DBA /Service Engineer

Confidential

Responsibilities:

  • Provided 24 X 7 dedicated production DB's supports for the Bing.
  • Server Application fine-tuning trouble shooting, Monitoring MS SQL Server performance and windows server issues.
  • Worked on servers patching and password changing on frequently.
  • Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Hands on experience on DB deployments and configurations.
  • Implemented two and three node clusters and configured SQL on clusters.
  • Worked on daily activities like jobs monitoring, space alerts, troubleshooting, backups verification and jobs scheduling.
  • Troubleshooted all types of clustering issues and solved successfully.
  • Good knowledge on scom and mom.
  • Implemented log shipping, mirroring, clustering and replication.
  • Implemented cluster based mirroring from one datacenter to another datacenter.
  • Implemented and configures SQL Server 2005 Transactional Replication for reporting instance as subscriber for production use.
  • Coordinated with SAN team to resolve the IO issues on Storage level.
  • Creating SSIS packages for maintenance and data extraction and loading.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with SQL server Profiler generated traces to optimize the performance of the database.
  • Rebuilding indexes on various tables.
  • Using SSIS packages for daily maintenance jobs.
  • Resolving locking and blocking issues and worked on Active directory.
  • Planned and modified the permission issues in the production servers.
  • Installed and configured SQL Server 2005 32-bit in a Test Environment and migrated tested databases to production server.
  • Assisted other teams in locating bottlenecks, and recommending solutions.
  • Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data.
  • Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
  • Experience in up gradation from MS SQL Server 7.0 to MS SQL Server 2000 and MS SQL Server 2005 to MS SQL Server 2008 R2.

Environment: SQL Server 2008 Enterprise Edition R2, OLTP OLAP, SQL Server Reporting Services 2000/2005, Windows 2000 Advanced Server, Windows 2008 Enterprise Edition, Idera Diagnostic Manager, Lite speed

SQL Server DBA

Confidential

Responsibilities:

  • Conducted various meetings and conferences with application teams to meet corporate milestones for database Standards.
  • SQL Server 2000, 2005,2008 Performed installation of SQL Enterprise 2005 64bit version and SQL Enterprise 2005 32bit version, service packs on Windows 2003 servers on Enterprise systems of clustered and standalone servers in enterprise Data Centers.
  • Installed SQL Server 2008 and migrated databases from Sql Server 2005 Side By Side Migration
  • Worked on upgradation like Upgrade In Place, side by side from sql server 2000 to sql server 2005
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
  • Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
  • Experience in programming SQL Server 2005 Reporting Services to create Adhoc reports using Microsoft Visual Studio.
  • Worked on clustered Sybase servers and monitored the activities.
  • Set up Database Mail and Created Jobs to Automate Scheduled many tasks.
  • Worked on Active directory, DNS and IIS servers.
  • Resolved the replication issues in both Sybase and SQL Servers.
  • Configured Transactional Replication, Database Mirroring and Log shipping with as well as basic account management and troubleshooting with connectivity, DNS and security issues
  • Configured Database mail, linked servers in sql server 2005.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
  • Performed Production support and on Call duties.
  • Worked on TSM tool for the backups and DB activities.
  • Executed Change control management on weekly and monthly basis.
  • Created monitoring scripts to alert for production issues.
  • Performed various types of Recovery scenarios using Sql server 2005 and sql lite Speed.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SQL Server Reporting Services 2000/2005/2008, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, sybase Windows 2008 Enterprise Edition, SharePoint, MS CRM, TFS, SCOM, MOM, IIS 5.0/6.0/7.0.

SQL Server DBA

Confidential

Responsibilities:

  • Provided 24 X 7 dedicated supports for the patient records database.
  • Server Application fine-tuning trouble shooting, Monitoring MS SQL Server performance and windows server issues.
  • Integrated SSRS with MS CRM and configured SSRS with MS CRM after migration.
  • Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Implemented log shipping in standby mode to support DR servers.
  • Suggested Transactional Replication model for reporting engine.
  • Documented and tested Transactional replication in test environment for generating reports.
  • Implemented and configures SQL Server 2005 Transactional Replication for reporting instance as subscriber for production use.
  • Experience in creating SSIS packages and their deployment.
  • Creating SSIS packages for maintenance and data extraction and loading.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with SQL server Profiler generated traces to optimize the performance of the database.
  • Created the MS DTS packages for executing the required tasks
  • Rebuilding indexes on various tables.
  • Using SSIS packages for daily maintenance jobs.
  • Resolving locking and blocking issues.
  • Planned and modified the permission issues in the production servers.
  • Installed and configured SQL Server 2005 32-bit in a Test Environment and migrated tested databases to production server.
  • Migrated, tested and automated DTS packages to SQL Server 2005 Integration Services.
  • Assisted other teams in locating bottlenecks, and recommending solutions.
  • Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data.
  • Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
  • Experience in Upgradation from MS SQL Server 7.0 to MS SQL Server 2000 and MS SQL Server 2000 to MS SQL Server 2005.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Server Reporting Services 2000/2005, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Idera Diagnostic Manager.

SQL Server DBA

Confidential

Responsibilities:

  • Designed and implemented multiple systems using MS SQL Server 2000
  • Prepared Estimates for Database, table size growth.
  • Responsible for MS SQL Server 2000, configuration, applying Service Packs and Hot Fixes and provide 24 7 dedicated support to all Production, development and clustered servers.
  • Installed and configured Microsoft Clustered SQL Clusters.
  • Performed all aspects of database administration, including data modeling, backups and recovery.
  • Setting up SQL Database Mirroring.
  • Maintaining filegroups for VLDB's and the transaction log monitoring for VLDB's.
  • Created the logical and physical data modeling using Erwin tool.
  • Created Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Developed database monitoring and tuning strategies.
  • Loaded data using BCP utility.
  • Configured the Log shipping and created the Standby server.
  • Involved in Upgrading the MS SQL Server from 2000 to 2005
  • Configured Log shipping from the production server to the reporting server.
  • Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
  • Implemented and configured Transactional replication.
  • Hands on experience with DTS/SSIS, Reporting services in 2000/2005.
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Involved in database builds and change control process.
  • Preparing the reports for the day-to-day as well as weekly/monthly purposes.
  • Wrote and integrated Stored Procedures to generate the Reports.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations.
  • Involved in capacity planning in estimating and sizing of Databases and working with NetApp systems.
  • Performed daily support, troubleshooting, monitoring, and optimization to improve performance using database engine tuning advisor for a ll SQL server environments.

Environment: MS SQL-Server 2005/2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Reporting Services 2000/2005 Idera Diagnostics Manager.

SQL Server DBA

Confidential

Responsibilities:

  • Installed and Configured SQL Server Cluster on SQL Server 2000 with Windows Server 2003 Enterprise Edition.
  • Configured Active/Passive Clustering for failover on development and production server.
  • Responsible for MS SQL Server 2000 configuration, tuning provide 24 /7 production support to Production, Development and Clustered Servers.
  • Scheduled Jobs and Maintenance Plans for Development Production environment for backup and recovery, replication verification, database integrity verification and indexing updates with SQL 2000.
  • Used Index Tuning Wizard to rebuild indexes for faster query responses.
  • Maintain Operators, Categories, Alerts, Notifications, Job. Monitor connections, locks and performance of SQL server.
  • Configured SQL Server 2000 in-built log shipping from primary server to hot backup server.
  • Written queries using Inner join, Left-Outer join, Right-Outer join Cross join.
  • Written Inline and Scalar User Defined Function and implemented Instead Of After Trigger specified their order of execution.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Loaded data using BCP utility.
  • Involved in Creating tables, indexes and designing constraints.
  • Successfully Configured Snapshot and Transactional Replication with Queued Updating.
  • Configured Snapshot Replication Creating Distribution Databases, updating Publishers, creating and managing Publications, managing Replication monitors .
  • Performed analysis and design of the application.
  • Performed database administrative job of Security Backup/Recovery.

Environment: MS SQL Server 2000 Enterprise Edition, MS Windows Server 2003 Enterprise Edition.

Hire Now