We provide IT Staff Augmentation Services!

Senior Sql Server Dba/systems Administrator Resume

0/5 (Submit Your Rating)

Emeryville, CA

SUMMARY

  • 20 years of professional experience designing, developing and implementing relational database management systems. Expert noledge with Confidential technologies: Confidential SQL Server (6.5, 7, 2000, 2005, 2008, 2008R2/2012/2014), SSAS (2000, 2005, 2008, 2012), PostgreSQL (8.4.1, 8.3.8, 8.2.14), FoxPro (DOS 2.5, 3.0, 95, 97, 2000, 2003), Access (2.0, 95, 97, 2000, 2003, 2007), MySQL (4.1, 5), and Sybase Adaptive Server 11.5, Oracle (8i/10g/11g/12G), Progress DB Open Edge v9/10
  • 13 years’ professional experience reporting design and development. Development tools: Crystal Reports(3, 6, 10, 11), Confidential SQL Server Reporting Services (SSRS), SharePoint (2007), ProClarity Analytics (6.3), Confidential Access Reports, Visual Basic (6) Report Writer, Confidential Word and Confidential Excel.
  • 8 years’ professional experience developing client - side website and 32bit applications.
  • Over 20 years’ experience, development and support with Confidential SQL Server, all versions up to version 2016
  • Over 7 years’ experience, development and support with Mongo DB, all versions to current
  • Over 7 years’ experience with Hyper-V and VMWare
  • Expertise with Oracle RDBMS 8i/9i/10g/11g/12c.
  • Expertise with Oracle Real Application Cluster (RAC) 9i/10g/11g/12c.
  • Expertise with Oracle Data Migrations (9i to 11g/12c).
  • Expertise with Oracle Database Appliance (X4-2, X3-2) installation, configuration and administration.
  • Over 3 years’ experience and development and support with Amazon Web Services (AWS) and OpenStack
  • Over 7 years’ hands-on experience with Data Center Consolidations and Migrations (Physical and P2V)
  • 7 years’ experience developing two, three-tier systems, and N-Tier systems using various methodologies.
  • 7 years’ experience in web development utilizing IIS, ASP, ASP.Net, and C #, ADO.NET, XML, CSS, JavaScript, HTML, DHTML, VBScript, FTP, Java and HTML.
  • Migrating from SQL Server 2000 to SQL Server 2005/2008/2012 by In-place upgrade process and as well as side-by-side upgrade process.
  • Installing, upgrading and configuring Confidential SQL Server 2000/ 2005/2008/2012 instances and its various components like Integration Services, Reporting Services, Client and Connectivity Tools and Analysis Services etc.
  • Installed and administered two node Active/Active cluster on MS Windows Server 2000/2005/2008 /2008 R2.
  • Implemented side by side Migration of MS SQL server 2000 to 2005/2008R2/2012 and applied Patches and Service packs to update different versions of MS SQL server.
  • Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
  • Configured more than 2 GB of RAM on 32 bit clustered and standalone environments.
  • Handled up to 2 Terabytes Size databases in clustered and Log shipping environment
  • Expert at SQL Server 2008/2012 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Object Search, Object Explorer Details, Activity Monitor, Multi Server Query, Intellisense in Query Editor and T-SQL Debugger.
  • Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
  • Expertise in RDBMS S/w Installation, applying patches, upgrading, configuring, managing, monitoring disk space usage, and database integrity/consistency and troubleshooting of SQL Server 2008 R2/05/00/2012 on Windows 2008/03/00 servers built on Clustered & Stand Alone Servers.
  • Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication (Transactional and Snapshot Replication), Confidential SQL Server Clustering 2012 Always On
  • Expert in Performance tuning of Database Management Systems (i.e. Table/Index Partitioning, T-SQL Performance Tuning, etc.)
  • Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables using different data warehouse styles (star and snow-flake schema).
  • Explicitly used third party tools like lite speed, Fog light and Red gate.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
  • Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup and fuzzy Groupings.
  • Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Excellent skills in database Backup, Recovery, Linked Servers, Database Maintenance Planning.
  • Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
  • Supported High Transaction SQL Databases in excess of over 100 million records of data each day / code
  • Expertise in planning, implementing Database Security by creating users, Roles, and assigning permissions to them.
  • Experience in creating and scheduling DTS and SSIS packages, SQL Mail Setup, Jobs, and Alerts.
  • Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
  • Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
  • Configure Database Mirroring in Cluster Environment.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
  • Management of schemas, Data modeling, objects & partitioning the tables & indexes.
  • Configuration and Administration of Share Point 2007.
  • 24 X 7 Production Database on Call Support.
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL Server DBA/Systems Administrator

Responsibilities:

  • Provided support of development, QA and Production Confidential SQL Server 2008 R2, 2012, 2014 and 2016 Instances/Databases
  • Performance tuning (indexing, stored procedures, batch processes)
  • Table/Index Partitioning for very large tables
  • Install and configure Fog light for monitoring of Production SQL Server’s
  • Support for Fail-Over/SQL Server Clustering (Installation and configuration)
  • Confidential Data Protection Manager (DPM) - backup all systems
  • Confidential SCOM - For monitoring and performance tuning.
  • Setup and Configuration of SQL Server Replication
  • Configure Publishers and Subscribers
  • Transactional, Merge, Peer-to-Peer and Merge Replication from SQL Server’s in the Montreal and Boston Data Centers to Data Centers in California and China
  • Development with Visual Studio 2012/2013/2015 (SSIS) - ETL Packages, support current BI Team
  • Upgraded VS from legacy Visual Studio 2005 to VS 2013
  • Migrated and Converted all SSIS Packages (200) to VS 2013
  • Installation, administration and support Cassandra 3.7
  • Security, Administration, Maintenance, back and Recovery and High Availability
  • Setup and configure Vulnerability and Security Penetration Testing
  • For all our Confidential Windows and Linux Servers in Boston and Montreal
  • Setup scripts and batch jobs for weekly Security Vulnerability and Penetration Testing using:
  • Rapid7 Nexpose Vulnerability Scanner - For our internal testing and;
  • Masergy Vulnerability Security Scanner - For External testing of all open TCP,UDP, …Ports
  • Recommend and Implement Security Hardening:
  • Windows Host Security Hardening
  • Linux Host Hardening using SE Linux
  • Network Security Hardening (disabling unused ports, enforcing firewall rules)
  • Web/Application support (Linux, Node.js, Python and Perl, PM2, NVM-Node Version Manager and NPM - Node Process Manager), Dev., Test and Production
  • Team lead, Architect for Data Center Consolidation and P2V migrations of Development, QA and Production Web Applications
  • Linux Shell Scripting, Ruby Scripting, Python Scripting and Perl
  • Developing interfaces, Node Micro services, batch jobs and Messaging with RabbitMQ
  • Migrated Web Applications (Node.js/Java Script Micro Services) - P2V (Hyper-V) Hardware Consolidation
  • Over 100 individual Web Applications
  • OS Migration from Sun Solaris (Joyent) to RedHat Linux/Centos
  • 20 Windows Server 2008 R2 with Upgrades to Windows Server 2012 R2
  • Physical to Virtual Data Center Migrations (P2V)
  • Bare Metal build/OS install, OS Packages, DNS and Network Configuration
  • Security
  • Network configuration
  • Configure Backups with DPM
  • Support for RabbitMQ in Development, QA and Production
  • Support, Installation, Configuration, Management (Administration), Development: (In support of Shark Ninja Customer Web Sites, Marketing Information, Sales and Product Information)
  • Rocket UniData v8.1.1 (Linux)
  • Rocket UniVerse v11.2.5 (Linux)
  • Rocket D3 (Windows)
  • Rocket U2 Development Platform
  • SystemBuilder v6.4.1
  • Support QlikView Applications on Windows Server 2012 R2 and batch processes
  • Development, QA and Production support for Node.js Web Applications
  • Support for JAMS Batch Scheduling
  • Installed, configured MySQL Cluster CGE ver. 7.2 (Linux) - DB’s For External Web Applications
  • Setup/configured replication between data center and DR facility
  • Write procedures, creating tables and indexing
  • Performance tuning
  • Backups with MySQL Enterprise Backup and MySQL Dump
  • Monitoring with MySQL Enterprise Monitor
  • Responsible for supporting 12 Mongo DB (3.X) Instances (Linux and Windows Server 2012 R2)
  • Designed and Configured an (11) node Sharded Cluster with Replica Sets
  • 3 config servers, 2 application servers with Mongos, 2 Primary/4 secondary
  • Backups/Restores mongoexport, mongoimport, mongodump, mongorestore
  • OpsMgr and Mongo Cloud
  • Administration support with Mongo Cloud, and all utilities
  • Setup/support for daily backups
  • Participate in daily/weekly meetings
  • 24x7 On-Call Support/rotations

Confidential

Confidential SQL Developer/SQL Architect

Responsibilities:

  • Provided support of development, QA and Production Confidential SQL Server 2012 Instances/Databases
  • Manage/Configure SQL Server 2012 in Confidential Azure Cloud
  • Responsible for design of database Data Model, Logical and Physical Design
  • Development of Stored Procedures, functions, views
  • Load/ETL for Oracle 11g to SQL Server 2012
  • SQL Server Migration Assistant for Oracle
  • Install and configure Oracle 11g/Oracle Enterprise Linux on Oracle Elastic Cloud (VM)
  • Configure SSH for Linux
  • Import 1TB of Oracle exports (Partitioned data)
  • Data Center Migration of all SQL Server Instances and databases to Confidential Azure Cloud, including all Apache and IIS Web Applications
  • Migrate Oracle data to SQL Server 2012

Confidential

Senior SQL Server DBA/SQL Architect

Responsibilities:

  • Provided support of development, QA and Production of Oracle Instances
  • Installed an configured Oracle 11g in Dev., Stage, QA and Production
  • Migrated Oracle databases from legacy hardware to Oracle Virtual Machines in Confidential Data Centers.
  • Data Center Consolidation and Migration
  • Moved/Migrated over 400 development, QA, and Production Linux and Confidential Windows Server’s with IIS Web Applications from Express Scripts and RX.COM Data Centers to Confidential Diagnostics Data Center’s (QDC1, QDC2 and QDC3)
  • Physical/Bare Metal installs/platform migrations
  • Physical to Virtual (P2V) Migrations, from Legacy Unix Operating Systems to RedHat Linux/Centos
  • Patched and upgraded Oracle
  • Setup and configured RMAN for backups
  • Provided detailed documentation on all processes.
  • Configured Symantec VCS for fail-over clustering
  • Supported Align Sys admins
  • Daily meetings with Confidential and Align
  • Responsible for Sybase ASE (15), Sybase IQ, Sybase Replication server database administration. Primarily responsible for database design, data warehouse administration. Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve the best performance and writing automated database monitoring scripts.

Confidential

Senior MySQL DBA/ETL Developer

Responsibilities:

  • Provided support of development, QA and Production MySQL Instances/Databases
  • Manage/Configure MySQL in Amazon Web Services/RDS (Cloud)
  • Responsible for design of database Data Model, Logical and Physical Design
  • Development of Data Model and ETL Design tasks in Agile/Scrum environment
  • Scope and complete daily/weekly Sprint tasks/Stories
  • Responsible for development of Clover ETL Job Flows and Graphs for load of external data sources and Customer data (Medical/Pharmacy) to MySQL databases/schemas and Mongo DB (Big Data) Collections
  • Create JSON Blocks/Format for load of JSON data to Mongo DB Collections
  • D3 - Used Tree Diagram generated from external JSON data
  • JSON data from Mongo DB
  • Load of external data and CSV data using D3 JavaScript
  • Handling dynamic JSON data via D3
  • Reading in data using D3 JavaScript (PostgreSQL DB)
  • Install and configure PostgreSQL DB - Migrate Data from Mongo DB Collections via JSON blocks to PostgreSQL DB
  • Monitor, Tune and backup PostgreSQL DB
  • Indexing for PostgreSQL DB
  • Data Modeling for PostgreSQL DB
  • High Availability for PostgreSQL DB
  • Responsible for Design and Architecture of ETL

Confidential

Senior Oracle DBA

Responsibilities:

  • Provided production, Quality Assurance (UAT) and development support for Oracle 10g/11g.
  • Supported Oracle 10g/11g for Lawson Financials.
  • Supported Oracle 10g/11g for Power plant (System for Water and Sewer).
  • Maintained and upgraded current Power plant system and worked with vendor during upgrade.
  • Maintained security for Power plant.
  • Cloned Oracle databases from production to development and test (Expdp/Impdp and RMAN).
  • Developed disaster recovery procedures for Lawson Financials and Oracle 11g database.
  • Involved in 5 day DR exercise at IBM site in NY State.
  • Recovered Lawson Financials Database on DR IBM AIX Server.
  • Staff at DR location tested and confirmed Lawson Application/Oracle database.
  • Installed and configured Oracle Cloud Control 12c.
  • Configured user defined Metrics and Alerts (email).
  • Configured job scheduling, asset and configuration management, change management, metric thresholds, provisioning and patch management.
  • Deployed Agents to over 100 Oracle and Confidential SQL Server Instances.
  • Applied management packs.
  • Utilized ADDM, AWR and ASH for problem resolution and troubleshooting performance issues.
  • Trained Aqua DBA’s on how to configure and maintain.
  • Configured and maintained Oracle RMAN Catalog for daily backups.
  • Developed AIX Shell Scripts for maintaining file system.
  • Developed Crystal Reports for Lawson Financials and Human Resources (for budgets, purchase orders and work orders).
  • Deployed Crystal Reports to Lawson Business Intelligence (LBI) Dashboard.
  • Oracle Enterprise Performance Management (11.1.2.3) - OFSAA.
  • Funds transfer pricing, pricing management, profitability analytics, balance sheet planning, DB administration, reporting, patching and upgrades.
  • Weekly staff meetings on daily projects.

Confidential

Senior SQL Server DBA/Systems Architect

Responsibilities:

  • Involved in production, staging, QA and development support for Kenexa/IBM application Oracle databases.
  • Supported Oracle RAC 11g, Oracle RAC 9i and Oracle RAC 10g.
  • Installed and configured Oracle Database Appliance (X4-2).
  • Used ILOM and OAKCLI, deployed on virtualized platform, using ODA BASE Template, Configured Oracle Auto Service Request, installed Oracle Grid binaries and Oracle Database, setup and configured Oracle RAC, shared repositories, configured Linux OS and applied Oracle Patches.
  • Used ODA for production web Oracle Applications.
  • Maintained ODA in stage and production.
  • Oracle data migrations (9i to 11g).
  • Oracle archiving and Oracle partitioning.
  • ADRCI/Log rotate for Oracle maintenance log files, listener and alert logs.
  • Installed, configured and supported Oracle distributed document capture.
  • Installed database and configured server configuration.
  • Created application pools and configured capture security.
  • Involved in Linux/UNIX Shell scripting and automating of monitoring systems, disk usage, resources and ASM (capacity planning and forecasting).
  • Used Oracle Enterprise Manager 12c monitoring of production, stage, QA and Development Oracle Database Instances.
  • Migrated Dev, Test and Production SQL Server 2012 R2 Instances from IBM’s Data Center to IBM’s new Cloud
  • Data Center Consolidation and Migration
  • Migrated Oracle 11g database (2 TB) to Confidential SQL Server 2012.
  • Used Confidential SSMA (SQL Server Migration Assistant for Oracle 5.2.1259) Project (Oracle to SQL).
  • Mapping of Oracle and SQL Server data types.
  • Converted 50 Oracle 11g Schemas to Confidential SQL Server 2012 Schemas.
  • Used Confidential SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012.
  • Loading Converted data from oracle 11g to Confidential SQL Server 2012.
  • Assessment reports.
  • Backup and recovery procedures/jobs.
  • Converted PL/SQL Procedures, Functions and Packages to SQL Server Stored Procedures.
  • Performed in DEV, TEST and production environments.
  • Involved in Oracle database upgrades and patches.
  • Involved in staff meetings, team meetings, technical documentation and training.

Confidential

MS SQL / Oracle / EBS DBA & SME/ SQL Architect

Responsibilities:

  • Completed a review of best practices for both SQL and SSIS after an initial noledge transfer
  • Installed and Configured Confidential SQL Server Management Data Warehouse for Performance Metrics and Analysis for Data Warehouses
  • Analyzed and Reviewed ETL Processes from Production systems to Data Warehouse
  • Provided “Best Practice” and recommendations for Performance improvements
  • Reviewed and facilitate discussions to solidify a specific plan of action with the customer’s team.
  • Delivered scorecard to provide scoring and recommendations for the following:
  • SQL Server and DB Installation and Configuration
  • Memory Settings
  • Processor Settings
  • Disc Configuration (logical and physical configuration, e.g. data logs, temp dB’s)
  • Advanced Database Settings (server properties - advanced settings)
  • Database Settings
  • Files/File Groups (file size, growth, number of files)
  • Database Options (review options under Database properties)
  • Table Partitioning (necessity based on DB structure)
  • IO Sub System
  • Block Level Alignment (row sizing)
  • Network Interface Settings (SQL Client Connections, NIC Settings, etc)
  • SSIS/SSRS (SQL Server Integration Services)
  • Control Flow Performance (opportunity for running tasks in parallel)
  • Data Flow Task Settings
  • Look-up Task Settings (Caching Modes SSIS)
  • Conditional Split Task Settings
  • Cache/Buffer Settings
  • OLE DB Source/Destination (Commit Size, Rows per batch, etc)

Confidential

Senior SQL Server DBA

Responsibilities:

  • Worked on Client/Server tools like SQL Server Management studio (2000), SQL Server Enterprise Manager (2008R2) and Query Analyzer to Administer SQL Server.
  • Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
  • Migrated DTS packages into SSIS packages.
  • Configured Transactional replication on migrated server.
  • Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
  • Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
  • Supported High Transaction SQL Databases in excess of over 100 million records of data each day
  • Managed trouble shooting of Client connections, viewing error log and applications.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
  • Worked on enhancing the application specific data sources and added new fields according to the requirement.
  • Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
  • Creating and implementing 2008R2 concepts like DMV’s, DMF’s, Data partitioning, online indexing.
  • Configured more than 2 GB ram on 32 bit Environment.
  • Tuned stored procedures by adding the try catch blocks for error handling.
  • Removed excess indexing by using the index include clause.
  • Implemented the online indexing on 24X7 environments.
  • Created the documentation for issue diagnostics reports.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
  • Involved in DATA Analysis like Analyzing and Accessing collection of Data.
  • SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, and Auto trace, TKPROF and tuned them to suit SLA.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
  • To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
  • Designed and implemented XML extraction code in Python modules for extracting XML documents in readable format for management. Wrote mission critical reports in SSRS for management
  • Extensive ETL processes designed and developed for the migration of data from PostgreSQL to SQL Server 2008.
  • Utilized SSIS for BCP processing of data from RPData in Australia to store data locally. dis allowed data schema changes and manipulation of data for custom analyzing of data for company requirements in SSRS.
  • Rewrote DTS packages into SSIS for FTP transfers of large amounts of data
  • Wrote real estate based critical reports requested from other departments for their use.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows 2003 64-bit, SQL/PL SQL, DTS, SSIS, Profiler, Lite Speed.

Senior MS SQL DBA/Architect

Confidential, Emeryville, CA

Responsibilities:

  • Designed and developed a SQL Server 2005 mirroring infrastructure for data and hardware redundancy system. I designed a new data recovery system for catastrophic events dat data recovery can be recovered quickly and safely, allowing short turn-around time.
  • Designed reporting tier for reporting requirements with SQL Server Reporting Services (SSRS) and created reports for management and other very essential reports with SSRS and C#.
  • Analyzed and rewrote problematic areas for reporting and processing needs within the company. The results provide more accurate figures on a timely basis.
  • Administering and maintaining large SQL Server 2008, 2005 and 2000 databases with more than 100 million records in individual tables.
  • Database Design and maintenance for trading data services and collaboration services for users of financial community (traders, bankers, hedge fund managers);
  • Maintaining database security and application security framework using security matrix, windows based group memberships and database roles.
  • Table Partitioning for existing and new application databases.
  • Developing Reports using SQL Reporting Services.
  • Disaster Recovery planning and implementation - Database mirroring, Log shipping, Active Passive clustering
  • Documenting install guides, release notes, change control documents.
  • Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations
  • Creating SSIS package based jobs for bulk data loading, updating and exporting.
  • Supporting production issues during work and after hours as required.
  • Migration from SQL 2000 and SQL 2005 databases to SQL Server 2008 64bit Enterprise Ed.
  • Monitoring SQL Services using MOM, SQL Sentry.
  • Backups and Restore using Lite speed for SQL Server
  • Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
  • Integrating MS Active Directory with database security to provide single sign-on
  • Experience in implementing single sign on technologies using LDAP and Active directory
  • Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV)
  • Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
  • Using SQL Server Service Broker to create asynchronous message based database update services.
  • Extensively using XML for input and export operations.
  • Using collabnet for version control of Database code.
  • Creating and managing PowerShell scripts for automating database tasks like upgrades.

Senior SQL Server DBA/SQL Architect

Confidential, CA

Responsibilities:

  • Managed and Administrated SQL SERVER 2008/2000 on highly transitive Production environment and Installed and setup SQL Server 2008 instances on clustered environment.
  • 24x7 production support SQL server 2008 Database administration
  • Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2005/2008 on Windows.
  • Implemented Transactional Replication on MS SQL server 2008 as a part of disaster recovery strategy
  • Applied Service packs and patches and hot fixes on clustered nodes
  • Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
  • Configured the AWE and /3 GB switch for the 32 bit 2005 server.
  • Upgraded/Migrated 15 Terabyte Data Warehouse (MS-SQL Server 2005) to Confidential SQL Server 2008R2
  • 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 the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache 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.
  • Extensively used lite speed backup with MS SQL SERVER 2005/2008.
  • Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
  • Managed multiple MS SQL 2008 RDBMS on Web-based, transactional platform
  • Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
  • 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 TSQL.
  • Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
  • Created baseline and sampling intervals in Perfmon considering threshold values of the counters.
  • Rebuilding indexes with different fill factors and update statistics manually.
  • Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
  • Generated reports in SSRS using BIDS (Business Intelligence Development Studio)
  • Rendered DRILL DOWN, STATIC reports in MATRIX form in SSRS
  • Used SSIS packages to move data from dev to QA and QA to Production
  • Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
  • Deployed SSIS package for bulk insert and maintained archival data.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

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

Senior MS SQL DBA

Confidential, Palo Alto, CA

Responsibilities:

  • SQL Server 2005 64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
  • SQL Server 2008 Installation.
  • Writing batch scripts to do automation of database tasks.
  • Writing scripts to manage different servers for auditing purpose.
  • Running packages as for system promotion requirements.
  • Lead on Migrating and Consolidating SQL Server 2005 Production server from 4 Data Centers to 2 Data Centers
  • Migrated all IIS Web Applications to the 2 Colocation facilities
  • Solving Memory Problem related with SSIS Packages.
  • SQL Server Analysis Services 2000 installation and Reporting Services 2005 installations on existing SQL Server Instances and SQL Server 2005 installations.
  • Performance tuning on different Production Servers.
  • Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
  • Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
  • Implementation of SQL Principal, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Solving memory related problems by changing server configuration settings.
  • Rebuilding indexes with different fill factors and update statistics manually.
  • Building Maintenance plans for database maintenance.
  • Writing stored procedures as for business requirements.
  • Backup and Restore databases.
  • Moving Tempdb to different file location.
  • Shrinking the data files as the space requirements.
  • TEMPEffectively used PL/SQL advance features like collections, ref cursors, dynamic SQL and bulk loading.
  • Managing users and security.
  • Managing schema objects, such as tables, indexes, and views.
  • Making database backups and performing recovery when necessary.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
  • Used Team Foundation Server 2010 for maintaining source control, data collection, reporting, project tracking
  • Involved in Configuration and Administration of Share Point 2007 environment.
  • 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005, T-SQL, Windows 2003/2008 Server, Team Foundation Server 2010, Oracle 10g,Vb.net,Asp.net.

Senior MS SQL DBA

Confidential, Houston, TX

Responsibilities:

  • Administration and Maintenance of SQL Server 2008, SQL 2005 and 2000 databases in test, development, and production environments for critical OLTP applications.
  • Database Design; Creation of tables (> 150), views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
  • Designed application database model using MS Visio for Enterprise Architect for FICA Refund claim processing and electronic data communication to/from JP Morgan Chase, data transmission to IRS
  • Setup Database Security and maintain accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
  • Monitoring database access users and roles using Idera SQLSecure.
  • Database Mirroring for SQL Server 2008, SQL Server 2005 database instances.
  • Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
  • Design, Development, Configuration and deployment of custom build business reports using
  • MS Reporting Services - SSRS.
  • Delivering Business Intelligence Data with Analysis Services Reports.
  • Design, Deploy and Process cubes for Data warehouse database.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
  • Resolving performance issues using DMVs (Dynamic Management Views), SQLDiag tool.
  • DTS, SQL Server Integration Services Package (SSIS) and Transact SQL Scripts.
  • Migrating legacy SQL server 2000 DTS packages to SSIS
  • Setup, Installation and Configuration of SQL Server RDBMS. Evaluating and installing patches/Service Packs.
  • Optimization, performance tuning of SQL Server Systems and databases.
  • Experience with setup/administration of SQL Server Profiles, database privileges & roles, LDAP and Active directory
  • Provide Reliability using transactional replication. Also deployed Double take for SQL for new server.
  • Analysis, development and maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
  • Configuring and Managing Idera SQL Compliance Manager to fulfill agency’s auditing needs.
  • Development of Data Transformation processes to Import & Export Data from variety of sources using
  • Active Directory, Exchange Admin, DBA/Architect
  • Using Database Mail for sending email messages from Jobs and Procedures.
  • Using CLR assemblies and CLR Types in SQL Server
  • Database Migration from SQL Server 2000 to SQL Server 2005 and SQL 2008.
  • Database mirroring for SQL 2008 instances.
  • Evaluating and deploying SQL Server 2008 in Development and Test Environments.
  • Using CDC (Change data capture), Table valued parameters and other new features in new applications.
  • Configuring and Evaluating SQL Server Audit, TDE (Transparent Data Encryption).
  • Adhoc data query and analysis for different SQL Server based Business applications for information and audit purpose as required by Business Users.
  • Working with testing team for testing of applications, Reports and other batch job processes as required. Generating test data as well as confirmation of testing operations from backend.
  • Documentation of SQL Server system and database operations, technical specifications, functional specifications, best practices, policies and procedures.
  • Perform after hours and weekend on-site or on-call support as needed.

Environment: SQL Server 2008 / 2005, SQL Server 2000, Windows server 2008, Windows server 2003, Transact-SQL, Idera Compliance Manager, CA ARC serve® Backup Utility, SQL Lite Speed, Double take for SQL Server, SQL Secure, MS Visio for Enterprise Architect, ADO.net, VB.net, SQL Server Reporting Services, Storage Area Network, Confidential Operations Manager

Senior MS SQL DBA

Confidential, Salt Lake City, Utah

Responsibilities:

  • Database Administrator/Database Programming/Product specialist.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on compliance issues.
  • Wrote the packages using DTS in SQL2000.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • Worked on key performance indicators for customizable metrics.
  • To set up SQL Server configuration settings.
  • Installed, authored, and managed reports using SQL Server 2000 Reporting Services.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Managed Disk space, memory and User connections.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Managing the clustering environment.
  • Using log shipping for synchronization of database.
  • To setup, implement, and maintain industry standards in database management.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Monitoring the servers using spot light third party Confidential software.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Implemented Data Access Layer using ADO.NET to communicate With the MS SQL Server 2005 Database.
  • Involved in developing user controls and asp pages.

Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.

Senior MS SQL DBA

Confidential, St Augustine, FL

Responsibilities:

  • Successfully designed, developed and implemented table partitioning (sliding window) on specific fact tables in SSAS; reducing cost on additional hardware.
  • Achieved high performance and more accurate ETL processes from OLTP to OLAP by rewriting the T-SQL scripts and utilizing SSIS.
  • Successfully migrated DTS packages to SSIS objects; allowing processes native to the new architecture, increasing performance.
  • Successfully designed, developed and implemented ProClarity Analytics utilized in Confidential SharePoint 2007. ProClarity development provided a clear and concise view of physician’s performance on the “Paid for Performance” program whereas prior physicians had to request custom reports. Department resources and delayed time for physician updates was removed from the process entirely.
  • Rewrote cubes, marts, fact tables, schema, MDX scripts and dimensions for the “Paid for Performance” program; providing a robust environment for handling future growth.
  • Successfully designed, developed and implemented a reporting tier utilizing SSRS and cubes for SharePoint 2007 portal reports, reducing bottlenecks resulting increase in performance.
  • Provided test environment with MS Virtual Server 2005 Cluster Server (active/passive) for testing data integrity from SQL Server 2000 (Cluster Services) to SQL Server 2005 (Cluster Services) before final push to production.

Senior MS SQL DBA

Confidential, San Jose, CA

Responsibilities:

  • Database administrator for the four terabyte SQL Server 2005 data center
  • Collaborated with marketing, finance and accounting department in which we successfully achieved numerous business goals for the company.
  • Successfully designed and implemented a colocation data center crash recovery system for sensitive stem cell research data; utilizing bit by bit replication between data centers.
  • Successfully designed, developed and implemented ETL processes using SSIS. The retention on the redevelopment of these processes kept a 98% data accuracy.
  • Advantageously setup a virtual active/passive Confidential Cluster Server landscape for testing migration from SQL Server 2000 32bit to SQL Server 2005 64bit. By utilizing experience with Confidential Virtual Server 2005; reduced the cost of migration two-fold.
  • Successfully migrated the active/passive MS Cluster Services from SQL Server 2000 (32bit) to SQL Server 2005 (64 bit) in production one week earlier than targeted date.
  • Headed all design and development on the SQL Servers requested by the Siebel development team.
  • Rewrote PostgreSQL scripts for enhancing ETL processes.
  • Designed and developed web services for handheld devices for urgent transfer of cord information utilizing C# and ASP.NET 2005.

Senior MS SQL DBA

Confidential, Huntersville, NC

Responsibilities:

  • Performance tuning of the SQL 2000 servers in order to reduce I/O and Memory contentions.
  • Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.
  • Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Confidential SQL Server 2000.
  • Developed SQL Server Maintenance Plans.
  • Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
  • Writing stored procedures and DTS packages for maintenance tasks in Production environment.
  • Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
  • Export or Import data from other data sources like flat files using Import/Export of DTS
  • Recovering the databases from backup in disasters
  • Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
  • DBA support for a development team customizing and testing new releases of client-server applications
  • Analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity and reusability of code.
  • Written Tested and Documented Program code and implemented programs.
  • Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: SQL Server 7.0/2000, Windows 2000, Visual Basic 6.0, Oracle 8i, Erwin

Senior MS SQL DBA

Confidential, Lombard, IL

Responsibilities:

  • Design and manage Heterogeneous ETL feeds using SQL Server, Oracle, DB2, and Teradata. Aggregate data feeds into reporting Data Warehouse using SQL Server 2005 stored procedures and SSIS DTS Packages.
  • Expert with SSIS ETL.
  • Ability to debug SSIS Packages and resolve issues at a very granular level . Create complex stored procedures, views, and functions.
  • Optimize environment using Dynamic Management Functions, Tuning Advisor, Execution Plans, and years of experience working with SQL Server Manage user security / database roles. Design table schema.
  • Create Management Decision Dashboards, displaying Key Performance Indicators derived from the Metrics stored in the Data Warehouse. SSRS with Dundas Charts and Graphs integrated into SharePoint is used for the Dashboards.
  • Expert with SSRS Reports.
  • Act as DBA for development and Data Warehouse environments. Manage Backups, Indexing, Space Requirements, Production Deployment, daily scheduled Jobs.
  • Utilize daily subscriptions to analyze and report on daily Data Load Status, so we are aware of problems before our end users are.
  • Assist Manager by training other developers the established standards.

Senior MS SQL DBA

Confidential, Fresno, CA

Responsibilities:

  • Database administrator for the six terabyte SQL Server data stores
  • Provided DBA assistance with the Oracle and PostgreSQL databases.
  • Successfully setup crash recovery, backup maintenance and schedule, advanced connection pooling, and performance tuning.
  • Created custom daily and weekly maintenance on all SQL Servers allowing for optimal performance. Extensive fine tuning with ADO.NET objects for connected and disconnected data processing.
  • Successfully designed clustered servers architecture for high activity servers for failover and hardware redundancy.
  • Successfully designed, developed and implemented stores, listings, and check out for easy seller site with Ebay.
  • Redesigned PostgreSQL schema’s to 3rd and 4th level normalization.

Environment: SQL Server 2000/2005, SQL Server Reporting Services, SharePoint and Confidential Cluster Services (MSCS).

Senior MS SQL DBA

Confidential, Houston, TX

Responsibilities:

  • Performance tuning, Data Modeling, and ETL Data Migration for three simultaneous projects.
  • Establish normalized database schema using SQL Server 2005 Beta 3. Create SSIS (SQL Server Integration Services) packages to load data from various sources such as Oracle, Text, Excel, and SQL Server into a central Data Warehouse.
  • Utilize SQL Plus and Toad to validate Oracle data mining. ETL Data Migration using DTS and VB Script . Create DTS packages to load all files in a directory in a loop while detecting the correct import type and then passing the file to the appropriate DTS Data Pump. Performance tuning on slow running processes.
  • Profile all stored procedures created by programmers and drastically reduce processing time. Create complex triggers to accommodate business logic.
  • Eliminate all table scans, create needed indexes, and re-write queries to use optimized t-sql. Show developers proper usage of advanced joins and cursors.
  • Data Warehousing (OLAP) with Confidential Analysis Server and SQL 2005 Business Intelligence workbench. Perform data partitioning for terabyte size databases with tables consisting of more than 200 million rows, to utilize multiple RAID 10 drive arrays on EMC CX700 SAN. Setup disaster recovery and maintenance plans for production environments running on Windows 2003 64 bit Clustered architecture.

Senior MS SQL DBA

Confidential, Tulsa, OK

Responsibilities:

  • All aspects of Database Administration and Development using MS-SQL Server 7.0/2000.
  • Designing the SQL database objects for the new enhancements in the project
  • Backend programming for the project
  • Performance tuning stored procedures and database objects.
  • Actively involved in the development of application software, using VB 6.0, SQL Server 2000, ADO 2.6, Crystal Reports 8.5 etc.
  • Preparing different types of reports using SQL Server, MS Access and Crystal Reports 8.5
  • Taking database backups on disks as well as on magnetic tapes using VERITAS Backup Exec software.
  • Importing/Exporting data from and to heterogeneous data sources using DTS.
  • Creating scheduled backup jobs and managing them using the SQL Server Agent.
  • Writing Stored Procedures, Triggers, Cursors, Functions etc.
  • Creating database objects, such as, Tables, Views etc.
  • Creating Referential Integrity constraints.

We'd love your feedback!