We provide IT Staff Augmentation Services!

Sr. Sql Server Dba/developer Resume

5.00/5 (Submit Your Rating)

Brooklyn, NY

PROFESSIONAL SUMMARY:

  • Over 8+years of experience in Database Administration using MS SQL Server 2014/2012/2008/2008 R2/2005.
  • Experience in development with PowerShell scripting languages.
  • Experience in deploying, configuring and administering AlwaysOn in SQL 2012/2014
  • Experience in installation, maintenance ofdifferent versions of SQL Servers (2014, 2012, 2008R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments.
  • Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
  • Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
  • Experience in Migrating databases/servers from SQL 2008R2 and SQL 2012 by In - Place Upgrade Process and 2005 to 2008 R2 by side-by-side upgrade process.
  • Design, Architect and capacity planning OLTP or OLAP requirements.
  • Monitoring Indexes for Performance Related issues PowerShell.
  • Experience and Knowledge on HA/DR like Log shipping/Mirroring/Clustering & Replication.
  • Extensive experience in implementing Clustering and Mirroring on physical and virtual machines.
  • Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.
  • Extensively worked on Active-Active and Active-Passive Clustering.
  • Successfully Implemented TDE (Transparent Data Encryption) to secure data at rest and document the process.
  • Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2012 Resource Governor and policy based management.
  • Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.
  • Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
  • Experience in working with DTS/SSIS (ETL) in SQL, 2008, 2012, 2014.
  • Experience in converting DTS to SSIS Packages.
  • Extensive experience in SDLC in developing an application, with Installation, design, architecture, data flow, Maintenance and Operations of a system.
  • Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management
  • Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
  • Experience in working with VLDB databases up to 16TB, Managing Backups, Disk & Drive Space issues, managing indexes, Partitioning, compression, free space etc.
  • 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.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
  • Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, Lite Speed, SQL sentry etc.
  • Good team player with communication Interpersonal and business analysis skills.
  • Extensively worked with DB2 Explain, Runstats , REORG and other ONLINE and Offline utilities .
  • Experienced in (24 x 7) Production Support.
  • Expert Level skills in providing 24x7 DBA Level 3 supports in Production, QA and Development.

TECHNICAL SKILLS:

Databases & Services: SQL Server 2000/2005/2008 /2012, MS-ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs,, ODBC, JDBC,DB2

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: T-SQL Programming, C# ASP.NET

Operating Systems: Windows XP/NT/ 2000/2003/2008, Vista, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.

Protocols: TCP/IP, HTTP, FTP, SSH, TELNET

Virtualizations: VMware VSphere client, ESX 3.0, 4.0 and ESXi4.1.

Data Modeling Tools: Erwin, Red gate, Lite speed, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Sr. SQL Server DBA/Developer

Responsibilities:

  • Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008/2008 R2/2005 on Standby Environments.
  • Supporting over 50 databases with few databases more than 16 TB.
  • In SQL 2008R2 set up Database Partitioning to improve query performance.
  • Upgrading our current SQL Server 2000 environment to SQL Server 2012.
  • Migration of a large number of DTS packages to SSIS Packages.
  • SQL Server (SSIS & SSRS) Development 2008 and 2012.
  • Database development and support in MS SQL Server environments
  • Working with developers to create store procedures, functions and views.
  • Performance Tuning of SQL Server 2008R2 environment with UAT load testing for capacity and performance analysis. New Application Snapshot deployment.
  • Maintained High Availability such as Replication (both Transactional and Merge replication) as far database disaster technique.
  • Prepare deployment packages and instructions. Perform said deployments in succession, handing these off for execution in production environment.
  • Standardize and automate packaging and developer handoff. Utilize TFS for collaboration and code safekeeping.
  • Set up Transactional Replication between Primary and many Secondary servers for reporting.
  • Implemented Resource Governor on SQL Server 2012.
  • Planned, Configured, Installed and Maintained for SQL Server in Clustered (Multi-Node) and Non-Clustered environments.
  • Extensive experience in supporting and developing high-availability client server OLTP and OLAP database applications.
  • Tuning database environments for OLTP or OLAP requirements as necessary.
  • Configured and Monitored Database Mirroring along with Log shipping
  • Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers with Updatable Subscriptions
  • Created stored procedures for the business logic using T-SQL.
  • Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Environment:: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5, T-SQL, SSIS, and SSRS, ETL.

Confidential, Boston, MA

SR. SQL SERVER DBA/DEVELOPER

Responsibilities:

  • Designed data models along with database schemas.
  • Performed successful Migrations SQL 2008 to SQL 2012 and Stand alone to cluster servers.
  • Implemented Disaster Recovery solution.
  • Reviewed complex data models and database schemas for suggestions/approvals and changes
  • Involved in the implementation of database changes closely with applications/Developers team, Data modelers.
  • Coordinate with Network and storage team for Planning, building and Performance tune Blade chassis at datacenter level.
  • Documented Best practices and Standards for database structures, for better performance of the SQL server.
  • Worked on Tuning of Stored procedures where locking, blocking and deadlocking are involved and also finding the root cause of it.
  • Involved in Change Management, Problem management, process management before implementing database changes in production and development activities.
  • Developed an Automatic process to Backup, Compress and FTP a zipfile.

Environment:: SQL Server 2008/2008R2/2012, Windows NT/2012/2008R2/2008, IBM Lombardi BPM 7.5,T-SQL SSIS, and SSRS, ETL.

Confidential, Pleasanton, CA

SQL Server DBA & Sybase DBA

Responsibilities:

  • Installed, configured and administered SQL Server 2008 and 2005.
  • Performance tuning at various layers including Data Model, Query Tuning, Index creation and maintenance, Hardware and network layer.
  • Creating database objects as per business requirements and Resolved CPU, Memory, and Temp DB related issues.
  • Performance tuning and rewriting Stored Procedures, Functions and Report Queries providing CPU savings and quicker Response Times.
  • Responsible for hardening the server to meet PCI and SOX controls and ensure that the database environment is according to health care compliance standards.
  • Reviewed changes using Red Gates SQL Compare and on validation and approval pushed objects into higher environments.
  • Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.
  • Created users and provided necessary privileges, Implemented Mirroring using witness server.
  • Expert experience in Replication and Troubleshooting issues due to Open Transactions, Locks, Deadlocks and query timeouts.
  • Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers. Worked with TOAD and LiteSpeed for Backup and restore.
  • Created DML/DDL triggers and constraints and Audited Server and provided documentation on server configurations and recommendations.
  • Created Data models to implement new application functionality as per business requirements.
  • Involved in Knowledge transfer and mentoring developers on best practices, better programming techniques and code reusability, aiding team in providing deliverables on time.
  • Coordinated with System Administrators in proactively resolving performance issues and reducing downtime.
  • Worked with SME's to better understand application and business requirements.

Environment: SQL Server 2005/2000 with clustering, Replication, ETL, DDL/DML, T-SQL, Sybase ASE 12, 15 .Sybase Replication.

Confidential

SQL Server DBA

Responsibilities:

  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.
  • Working experience on Active -Passive and Active -Active Clustering model.
  • Successfully migrated SQL 2005 mirror model to SQL 2008 cluster model.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Work with project teams for Migrating data from MS Access to SQL Server 2005/2008.
  • Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Configuring and Setting up BMC Patrol alerts in Production, Preview, QA & DR, Test environment.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Designing Logical and Physical Data Model with Erwin tools.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008, MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential

Jr SQL Server DBA

Responsibilities:

  • Installed SQL Server 2005 Servers and applied hotfixes and service packs for Production and Development environments.
  • Managed logins, roles, assigning rights and permissions to users.
  • Worked with running DBCC consistency checks and monitoring daily backups.
  • Monitored the use of disk space usage, memory and connections for the databases.
  • Implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.
  • Data refresh from production to various environments through backup/restore procedures.
  • Created DTS Packages to get the data into excel sheets, required by the management for analysis.
  • Prepared the deployment scripts and rollback scripts to migrate the Database environment objects into Production database.
  • Monitored the databases to ensure high availability of Production Servers.
  • Worked to establish connectivity between VB Applications and MS SQL Server by Using ODBC
  • Maintained version control of database releases and Object Changes.
  • Documentation for best practices, policies, procedures and standards.

Environment: SQL Server 2005, Windows NT/03, Visual Basic VB, DTS.

We'd love your feedback!