We provide IT Staff Augmentation Services!

Sql Server Dba/ssis Developer Resume

Corvallis, Or

Summary
Around 9 years of IT experience that includes administration, development, design, programming, support, and installation of MS SQL server. Worked as a DBA/Developer with databases and supported applications in various industries like financial services, Investment Banking, Health care and Retail/Manufacturing.

  • Hands on Experience in installing, configuring, monitoring, upgrading and troubleshooting MS SQL Server 2008/2005/2000.
  • Expertise in Installing patches, service packs and Hot Fixes to ensure maximum security.
  • Conversant with all phases of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
  • Experience in administrative tasks scheduling Backup & Recovery Strategies and Disaster Recovery Procedures.
  • Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
  • Experience in implementing different types of Replication Models like Snapshot, Transactional and Merge Replication.
  • Hands on experience in implementing and maintaining high availability/eventuality solutions Like Replications, log shipping, Database Mirroring and SQL Server Clustering.
  • Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
  • Excellent knowledge of Data Extraction, Transformation, Loading with Oracle, Mysql and SQL Server.
  • Experience in MySql and Oracle.
  • Experience in Data Migrations from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008.
  • Experience in working with Reporting tool like Microsoft Reporting services & handling Sub Reports and defining query for generating Drill Down reports using SSRS 2005
  • Proficiency in writing and debugging with SQL Server T-SQL in constructing triggers, stored procedures, user defined functions, cursors, views, indexes, relational database models, data integrity.
  • Expert in logical and physical modeling for OLTP and OLAP applications.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
  • Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
  • Expertise in creating Packages using SQL Server Integration Services (SSIS).
  • Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
  • Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle.
  • Responsible for enforcing video, audio, subtitle, metadata and artwork standards across an extensive library of television and film content
  • Verified DDL sent in from developers and data modelers that it complies with standards
  • Responsible in providing Development and Production Support 24x7 and off hours support.
  • Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.

Skill Set

Databases : SQL Server 2000/2005/2008 /2012 , Oracle 9i/10g, Solaris, Linux
Operating Systems : Windows 2000/2003 Server, 2008 and UNIX
Languages : C, C++, SQL, PL/SQL, T-SQL
Reporting Tools : SQL Server Reporting Services
SQL Server Tools : Enterprise Manager, Microsoft Systems Center Operations Manager, SQL Server Management Studio, Profiler, Query Analyzer, MS Visio
Applications : Visual Studio 2012/2010/2008 , Excel, Word, PowerPoint

Career Profile

Confidential, Corvallis, OR
SQL Server DBA/SSIS Developer

Confidential is an American multinational information technology Corporation, It provides products, technologies, software, solutions and services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors. I was working with the Enterprise Services as a DBA / Developer. The project involved in upgradation and migration from AWS to HP Cloud.

Primary Role:

  • Created Instances and databases for various Production and non-Production environment with size ranging from 500 GB to 3 TB.
  • Installed and configured SQL Server 2008 R2/2012 in production and non-production environments
  • Designed and implemented comprehensive Database Backup & Recovery Strategy
  • Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, functions and Stored Procedures.
  • I am playing lead role in HP. 3 juniors and 15 applications developers.
  • Involved in working with Visual Studio 2010 and DBDiff tool for SQL compare & SQL Data compare between the databases and tables.
  • Installed and implemented the backups tool SQL Safe in all environments.
  • Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
  • Created Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks completion.
  • Detach and Attach databases, manage and modify database files
  • Deploying database objects to development/testing environments
  • Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
  • Modified multiple DTS packages for migration
  • Created SQL Jobs, Database Maintenance plans Schedule for execution at specified time
  • Deploy, upgrade and configure new database and Coordinate database migrations with developers and other stakeholders.
  • Instrumental in development of BI solutions for complex business applications within HP that involves deep understanding of technical and business requirements.
  • Creating jobs for scheduling the SSIS packages.
  • Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
  • Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
  • Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices pack
  • Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
Environment: MS SQL Server 2012/2008R2/2005, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Logshipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Atlanta, GA
SQL Server/BI Developer

Confidential is a leader in Healthcare IT solutions for a wide range of facilities. AllScrips offers a variety of IT solutions aimed at employing technology to save time and money in the Healthcare field. These products vary in specialty from claim management, to medication dispensing, to electronic health records.

Primary Role:
  • Installation of Microsoft SQL Server 2008 R2, 2008 and 2005 on PROD, QA & DEV boxes.
  • Installed SQL Server 2008 on Active-Active and Active-Passive cluster on QA & PROD environments.
  • Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
  • Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
  • Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
  • Lead role in AllScripts.
  • Maintaining and Monitoring Production, Pre-Production and Development database server environment
  • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
  • Schedule informaticaWofkflows
  • Effectively configured MySQL Replication as part of HA solution.
  • Designed databases for referential integrity and involved in logical design plan.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Monitor InformaticaWorkFlow execution
  • Import/Export Informatica Workflows, Mappings, Workletsetc
  • Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
  • Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
  • Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
  • Writing Stored Procedures, Triggers, cursors and creating indexes.
  • Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
  • Teradata DBA in the Aviation Group
    • Verified DDL sent in from developers and data modelers that it complies with standards
  • Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
  • Scheduled and executed SSIS Packages using SQL Server Agent.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

Confidential, San Francisco, CA
SSIS Developer
Confidential provides consulting and information technology (IT) services to clients globally. The Company focuses mainly on healthcare IT services & BFSI sector. Its InfoTech services span the entire application lifecycle.

Primary Role:
  • Well versed with SQL Server 2005/2008R2 Installation, Administration and Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.
  • Developed T-SQL (DDL, DML) statements using dynamically generated SQL and defined Referenced relationships with the measure groups and fact tables.
  • Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
  • Planned the complete back-up of databases for disaster recovery scenarios.
  • Transferred data (ETL) to Data warehouse environment using SSIS.
  • Writing SQL Server Integration Services (SSIS) packages and deploy it in Development/Testing and production server.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
  • Writing Stored Procedures, Triggers, cursors and creating indexes.
  • Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns.
  • Planned the complete backing up of Databases and Disaster Recovery /Restore procedures
  • Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers.
  • Responsible for database development in SQL Server 2008, worked on T-SQL functions and SQL syntax.
  • Transferred SQL Server Objects from QA to Production Using SSIS Packages.
  • Used DTS Packages to move logins and jobs from one server to another server.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

Confidential, Santa Monica, CA
SQL Server/DBA

Confidential is the world’s largest and most profitable independent interactive entertainment publishing company. It develops and publishes some of the most successful and beloved entertainment franchises in any medium, including Call of Duty, World of Warcraft, Sky landers, and Diablo.

Primary Role:
  • Installation of SQL Server 2005/2008 on production, development and testing environments.
  • Worked on High availability options: Mirroring, Replication, Log Shipping (on its setup and failures).
  • Create Service Request TICKETS for customer issues that come in and see to it that it does not get out of SLA (Service Level Agreement).
  • Reset password for all our SQL/IIS and other accounts and then verify/reboot the servers if needed.
  • Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
  • Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle.
  • Created Perspectives & defined security, roles for different group of users.
  • Installing and configuring the SQL Server 2005 and SQL Server 2008 on windows 7 servers.
  • Creating New SSIS packages and Migrating SSIS packages from SQL Server 2005 to SQL Server 2008.
  • Implementing Backup and recovery process and Replication process.
  • Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
  • Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.
Environment: SQL Server 2000/2005/2008 , SSIS, Oracle, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL, Linux, Solaris.

Confidential ,Hyderabad, India
SQL DBA

Confidential is one of the world's largest financial institutions, serving individual consumers, small businesses, middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.

Primary Role:
  • Involved in business requirement gathering and development of functional and technical specification documents.
  • Extensively managed and administered SQL Server 2008/2005 and 2000 servers.
  • T-SQL & PLSQL programming for writing stored procedures, user-defined functions, Triggers, cursors, views setup and management of linked servers to Non-SQL-Server Databases.
  • Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
  • Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.
  • Creation and implementation of Database backup Restore and Recovery plans.
  • Replicating the database (Snapshot, Transactional and Merge Replication) and providing greater autonomy to the users.
  • Working on Log shipping, Mirroring and SQL Server Clustering Databases.
  • Involved in Installing patches, service packs and Hot Fixes to ensure maximum security.
  • Performed operating system and database upgrades as part of database analysis.
  • Experience in Security Issues such as creation and granting permissions on various Objects. Assign permission to user(s), role(s), and object.
  • Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
  • Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.
Environment: SQL Server 2000/2005, BIDS, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL, Linux, Solaris.

Confidential, Bangalore
DBA/Linux Admin/Windows Admin

We’re dedicated to the financial services industry. Our experts focus on the industry’s unique issues to deliver real value and create your competitive advantage.
Primary Role:
  • Involved in Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Monitoring SQL Agent jobs.
  • Monitoring and Managing use of disk space and connections.
  • Installing, Upgrading and Administrating Operating Systems and applying Patching & Packages for applications.
  • Setup, maintain and manage the User Accounts and groups.
  • Scheduling of automatic repetitive jobs using commands, and shell scripts with Corntab.
  • Install and maintain desktop workstations, printers and peripherals locally and remotely.
  • Windows Server 2000 and 2003 environment.
  • Configure/assemble/troubleshoot Desktop PCs/Laptops.
  • PC and laptop data migration.
Environment: SQL Server 200, Red Hat Linux, Solaris, HP-UX, T-SQL, Windows 2003/2005 server.

Hire Now