We provide IT Staff Augmentation Services!

Sql Server / Sybase Dba Resume

2.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • 7+ years’ experience as a SQL Server DBA to support Database Administration, Management Enterprise SQL Server Databases, and SQL Server Data Warehouses.
  • Extensive experience in SQL Server 2000/20 R2/2012 Database Administration.
  • Designed and developed ETL packages in SQL Server Integration Services (SSIS).
  • Experience in SQL Server Performance Tuning, application design, Disaster Recovery planning, security management, and managing servers and clients.
  • Experienced in database design, Relational Integrity Constraints, OLAP, OLTP data modeling and normalization.
  • Migrated SQL Server 2000 databases into SQL Server 2005 databases and SQL Server 2008 into SQL Server 20012 using best practices.
  • Installed SQL Server 2008 on new 32 - bit and x64-bit Operating System.
  • Highly proficient in database Backup, Restore, Recovery, Transactional Replication, Linked Servers, and Database Maintenance Plans.
  • Experience in SQL Server 2012/2008/2005 concepts including SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
  • Experience in High Availability and Disaster Recovery like Replication, Log shipping, Mirroring, and Windows and SQL Clustering.
  • Expertise and interest in performance analysis and production support for very large database (VLDB) and complex databases.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, DMVs, DMFs and Performance Counters.
  • Responsible for Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008/2012.
  • Expertise in planning and implementing Database Security by creating Users, Roles, and assigning permissions to them.
  • Experience with Oracle Enterprise manager Grid control 11G for high-level view of teh entire enterprise.
  • Extensive experience with T-SQL, Stored Procedures, Functions and enforcing business rules for business applications with DDL, DML, and DQL commands
  • Experience in T-SQL and PL/SQL developer skills, including stored procedures, Indexes views, User Defined Functions (UDF), Triggers, and Distributed Queries.
  • Working experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse applications.
  • Excellent in learning new technology and easily adapt to a new environment.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008 R2/2012, MS Access, Oracle 9.0, Sybase ASE 12.5.4/15.7

Database Technologies/Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, DTS, Replication, SSIS (ETL), SSRS, SSAS, Erwin, TOAD, Quest Litespeed, SQL Database Tuning Advisor, SQLIO, Benchmark Factory

Programming Languages: SQL, T-SQL, VB.NET,C#, XML, C++, Java, VB 6.0

Scripts: JavaScript, VBScript, Shall Script, HTML, XML

Web Tools: MS-Front Page, IIS, Outlook

Applications: Microsoft Office2003/2007, Visio, Visual SourceSafe, VMware

Operating Systems: Windows 9x/NT/2000/XP/2003/2008R2

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server / Sybase DBA

Responsibilities:

  • Responsible for Sybase 15 upgrade, SQL Server 2012 migration and Support to both databases.
  • Migrated new database structures, such as tables, indexes and stored procedures from development to Production environment.
  • Installed and configured Sybase 15.7 on New LPARs.
  • Responsible for many Sybase ASE 15.7 upgrade Projects from Sybase 11.9/12.5.4 to ASE 15.7
  • Worked on Infrastructure team with many responsibilities like design and build New servers on SQL Server 2008 R2/2012 and Sybase 15.7 environments.
  • Responsible for multiple Sybase to SQL Server migration.
  • Installed and setup SQL Server 2012 cluster configuration on Active/Passive nodes and Disaster Recovery.
  • Worked with 3rd party tools for SQL Server and Sybase monitoring like OEM 10g, 11g, Quest Sportlight and Orion Monitoring tool.
  • Experience on 3rd party database management tools like DBArtisan, SSMS, Sybase Central, Toad.
  • Configured teh RAID levels for data files, log files and tempdb at server level.
  • Analyzed long running, slow queries and tuned teh same to optimize application performance
  • Designed and developed FTP task using WS-FTP to transfer files from one server to another server (AIX and Solaris).
  • Implemented various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
  • Developed automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
  • Implemented database high-availability solution and Disaster Recovery for SQL Server
  • Implemented SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Involved in creating jobs in Control - M for server maintenance job schedule.
  • Extensive experience in Performance Tuning / troubleshooting using SQL Server Profiler to generate traces and identify query or resource bottlenecks.
  • Provide support for Sybase ASE and SQL Server 2008/2012 on a multi-terabyte system.
  • Developed monitoring scripts for Replication, memory, and row count consistency.
  • Provide experience in complex business projects and delivering high quality results,
  • Strong communication skills with Client Management.
  • Develop and deliver effective presentations and reviewed queries.
  • Provide support for tuning SQL Server performance issues.
  • Create training doc. for client DBA to use and maintain SQL Server & Sybase servers.

Environment: MS SQL Server 2005/2008 R2/2012, Windows 2003/2008 R2, Sybase ASE 11.9/12.5/15.7 , AIX, Solaris, SSRS, SSIS, T-SQL, Erwin, Toad, Sybase ASE, Sport light, WS-FTP, ESP. Control-M.

Confidential

SQL Server Developer / DBA

Responsibilities:

  • Responsible for teh migration of Windows Server 2003 to Windows Server 2008 R2 and Sybase anywhere to SQL Server 2008 R2 on Development, Test, DR and Production environments.
  • Migrated new database structures, such as tables, indexes and stored procedures from development to teh production environment.
  • Worked with application upgrade.
  • Installed and configured SQL Server 2008/2012 R2 Cluster and Standalone environments.
  • Configured teh RAID levels for data files, log files and tempdb at server level.
  • Developed all teh required stored procedures, user defined functions, and triggers using T-SQL.
  • Handled up to 1 TB GB sized databases with clustered and log shipping environment.
  • Analyzed long running, slow queries and tuned teh same to optimize application performance.
  • Configured WS-FTP client for file transfer from Mainframe servers to Production servers.
  • Designed and developed FTP task using WS-FTP to transfer files from one server to another server.
  • Implemented various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
  • Generated test data and tested database to meet teh functionalities deliverables in teh project documentation.
  • Performed Failover cluster support and resolution as well as monitoring and database backups.
  • Updated OLTP database statistics and re-indexed tables using DBCC commands.
  • Transferred and Managed SQL user logins, database user accounts, server roles, database roles and its permissions by developing a stored procedure sp help revlogin.
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes and scripts.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
  • Used SSIS to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
  • Involved in masking teh production data and transferred to Development environment.
  • Executed daily batch processes, and researched file share for a duplication project.
  • Developed automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
  • Implemented SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Developed monitoring scripts for Replication, memory, and row count consistency.
  • Performed day-to-day activities, such as backups to teh disk, restoring teh databases and monitoring database on production servers as per business needs.
  • Monitored teh performance of teh SQL server and teh system to identify hardware bottlenecks, operating system performance, index performance and queries with poor performance using SQL Profiler, Activity Monitor and SQL Server usage in Performance Monitor.
  • Running DBCC checks and fixing data corruption in application databases.
  • Optimized teh performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
  • Configured teh ESP Agent for scheduling teh daily batch processing and FTP File transfer.
  • Worked on desktop virtualization project.
  • Create training doc. for client DBA to use and maintain SQL server.
  • Provided 24x7 Production Database on-call support.

Environment: MS SQL Server 2008 R2, Windows 2003/2008 R2, SSRS, SSIS, T-SQL, Erwin, Sybase, Motivator, WS-FTP, ESP.

Confidential

SQL Server DBA

Responsibilities:

  • Provided 24x7 support for production systems.
  • Built scheduled-jobs to migrate data from flat files to database.
  • Performed backup and restore of large-scale SQL Server databases.
  • Performed SQL Server cluster installation. Worked on 32 bit, x64 bit and i64 clustered and standalone server environments.
  • Configured teh RAID levels for data files, log files and tempdb at server level.
  • Supported all FedEx third Party vendor applications using SQL Server and Oracle DB.
  • Performed database migration and configured database Recovery if necessary.
  • Supported and cleared teh database logs daily.
  • Kept existing system stable and available, and resolved end user issues as they arose.
  • Responsible for resolving blocking and locking issues.
  • Audited database configuration and security configurations.
  • Conducted performance monitoring, tuned T-SQL and database engines.
  • Developed all teh required stored procedures, user defined functions, and triggers using T-SQL.
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Created views to restrict access to data in a table for security.
  • Responsible for database maintenance and created maintenance SQL Stored procedures.
  • Performed regular installations and configured database management software (DBMS) and applicable service packs and/or patches.
  • Performed regular check, updated statistics and monitored security and hardware resource utilization.
  • Modified database structure including tables, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
  • Monitored performance updated statistics and rebuilt indexes at regular intervals for better performance.
  • Redesigned database architecture with teh help of teh Microsoft database development group and internal staff to increase application concurrency and performance.
  • Worked with 3rd party tools for SQL Server monitoring like Oracle Enterprise Manger 10g, 11g and Quest Sportlight.
  • Implemented data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
  • Managed logins and user accounts, including assigning database object permissions and ancillary privileges.
  • Participated in teh application development processes and code reviews of database objects.
  • Analyzed long-term databases performance trends to optimize database and application performance.
  • Maintained documents and implemented Disaster Recovery models.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, SSIS, SSRS, Oracle11g, Excel, Windows 2003/2008R2 Server, Visual Source Safe 6.0, Erwin 5.0, Benchmark Factory, OEM, FedEx Internal applications.

Confidential

SQL Server DBA

Responsibilities:

  • Installed Windows 2008 R2 Server OS by accessing teh Blade Servers using teh Integrated Lights-Out (ILO) link and clustering for Production, Stage and Development.
  • Installed Active/Active Cluster installation of SQL Server 2008R2, Oracle11g and DB2 on Production, Stage and Disaster Recovery new servers with hot fix CU5.
  • Installed SQL Server 2008 R2, Oracle 11g and DB2 on Development Standalone server.
  • Worked with 3rd party tool like LiteSpeed 4.1, 5.1, and 6.1 for Backup, Restore and Log shipping.
  • Worked with 3rd party tool like Benchmark Factory for SQL testing and even SQLIO for Benchmarking.
  • Extensively worked on Merge and Transactional Replication, Mirroring and Log-shipping for High Availability.
  • Migrated SQL Server 2005 to SQL Server 2008R2 on new ILO servers.
  • Developed Stored Procedures and Triggers for Security, Performance and Maintenance of databases.
  • Transferred and managed SQL user logins, database user accounts, server roles, database roles and its permissions by developing a stored procedure sp help revlogin.
  • Upgraded DTS packages to SQL Server 2008 R2 Integration Services (SSIS) packages.
  • Design and implementation of nightly run andbatchprocessingfinancial data.
  • Integration of various systems data via batch processing and posting back teh results to depended systems with SSIS.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers and identify CPU, Disk I/O and duration bottlenecks using trace files.
  • Moved all non-cluster indexes to a new file group for better Performance Tuning.
  • Performed daily backup and created UNC backup for production to save disk space.
  • Used MAGIC application software, an online Problem Ticketing and Chance Control Request System for User Request Problem resolution.
  • Worked on Oracle Enterprise Manager Grid Control 11g Oracle Agent for User monitoring.
  • Extensively work on Policy Based Management on SQL Server 2008 R2.
  • Administered teh MS SQL Server by creating user logins with appropriate roles, monitoring teh user accounts, granting teh privileges to users and groups.
  • Audited server for violation and took corrective actions as per company policy.
  • Designed a night run batch process to check daily inventory movement against sales data, invoice data and previous day’s returns dis nightly run ensures any mis-match in data extraction, integration. Reporting was done with SSRS, with daily email updates.
  • Developed reports using SQL Server 2008/2005 Reporting Services (SSRS).
  • Created Linked Servers between SQL server 2005/2008, Oracle and DB2 servers in teh environment.
  • Experience in mail enabling teh database server.
  • Maintained documentation for Cluster Build, SQL Server Security, etc.

Environment: SQL Server 2005/2008 R2, T-SQL, SSIS, SSRS, Oracle11g, Excel, Windows 2003/2008R2 Server, Visual Source Safe 6.0, Erwin 5.0, LiteSpeed 6.1, Benchmark Factory

Confidential

SQL Server DBA

Responsibilities:

  • InstalledSQL Server 2008/2005 on Development, Testing and Production environments.
  • Managed and administrated multipleSQL Server 2008/2005 and 2000 server instances.
  • Migrated SQL Server 2000 databases into SQL Server 2005 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
  • Design, migrated, deployed and monitored DTS packages into SSIS packages.
  • Maintained database maintenance plans and monitor alerts, jobs and notifications.
  • Transferred SQL Server Objects from QA Server to Production using SSIS Packages.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Handled up to 2 TB sized databases with clustered and replication environment.
  • Configured SSRS Reporting Server using Reporting Services Configuration Tool.
  • Created and deployed reports using SQL Server Reporting Services (SSRS) for business users.
  • Designed and developed FTP task to transfer files from one server to another server.
  • Extensive experience in Performance Tuning / troubleshooting using SQL Server Profiler to generate traces and identify query or resource bottlenecks.
  • Experience in creating new jobs, scheduling jobs, and setting job notifications/alerts.
  • Implemented SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilt teh indexes at regular intervals for better performance using DBCC DBREINDEX.
  • Maintained SQL Script for creation of Database Objects using VSS (Visual Source Safe).
  • Planned teh complete backing up of database and restoring teh database from Disaster Recovery by using LiteSpeed.
  • Transferred data from OLTP to OLAP (data warehouse) environment using SSIS packages.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
  • Created cubes using MDX query, diagrams, database design and performed logical modeling.
  • Developed complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and other SQL joins and statements for applications. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Monitored SQL server performance using Profiler to find performance and deadlocks.
  • Implemented new T-SQL features added in SQL Server 2005 to include data partitioning, error handling through TRY-CATCH statement, common table expression (CTE), data partitioning and snapshot isolation.
  • Extensive testing on teh performance of teh Stored Procedures using SQL Profiler/query plans.
  • Assisted based on teh requirement by using Joins, Sub Queries and Co-related Sub Queries.
  • ImplementedSQL Logins, RolesandAuthentication Modesas a part ofSecurity Policiesfor various categories of users.

Environment: SQL Server 2000/2005/2008 , T-SQL, SSIS,SSRS,SSAS, Excel, Windows 2003 Server, Visual Source Safe 6.0, Erwin 5.0, LiteSpeed

Confidential

Developer

Responsibilities:

  • Importing Source/Target tables from teh respective databases by using Control Tasks in SQL Server 2005 Integration services.
  • Created Transformations using Data Flow Tasks.
  • Created Event Handlers for teh Packages Using Event Handler Tab.
  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, and Sequential Container. Execute SQL Task, and Data Flow Task.
  • Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
  • Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
  • As per requirements developed teh reports in teh form of Matrix, Table and Chart using SQL Server 2005 Reporting Services.
  • Generated teh Reports Weekly and Monthly wise as per teh Client Requirements.
  • Involved ion creation and updates of several SQL tables and Procedures.
  • Creation of SQL Scripts and written Procedures using SQL data from uploading data from flat file into new tables.

Environment: SSRS 2005/SSIS 2005,SQLServer2005, Excel, C#

Confidential

Junior Developer

Responsibilities:

  • Provided database design support for new system development, and set SQL standards.
  • Developed complex T-SQL and PL/SQL code for data retrieval.
  • Responsible for backup/restore, database objects, such as tables, procedures, triggers, constraints, indexes and views, and user security management.
  • Developed backup restore scripts for MS SQL Server as needed.
  • Performed data retrieval by extensive use of multiple joins normalization and views.
  • Developed processes automation of maintenance jobs, tuning SQL Server, locks and indexes.
  • Wrote various stored procedures for teh purpose of application development.
  • Analyzed and designed Disaster Recovery / Replication strategies with business managers.
  • Conducted Performance Tuning, query-inventory, analysis and optimization.
  • Created and managed database users, login ids and security.
  • Performed data transfer (Import and Export) using DTS packages.
  • Responsible for performing complete backup and restoration, and database maintenance service pack updates on server and client.
  • Created Crystal Reports, hosting it in teh web for teh users.

Environment: Windows 2000, MS SQL Server 2000, T-SQL, PL/SQL, and Crystal Report

We'd love your feedback!