Senior SQL Database Administrator

Skills

Employment History:

Confidential

Sr SQL DBA

Responsibilities:

• Installed, configured and migrated SQL Server 2012, 2008 R2 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
• Involved in development activities including hardware installation and configuration, and participation in database design, architecture and SQL scripting.
• Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING
• Experienced in creating and modifying Graphical and Tablix reports using SSRS.
• Implemented Database Mirroring on SQL Server 2008 environments.
• Maintained data replication using SQL replication and Sybase replication.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Update the SSRS reports with different location and period hierarchy.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• Architected, designed and developed Emerging DaaS Database as a Service .
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Supported SQL Server environment in OLTP and DSS systems
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Upgraded SQL Server 2005/2000 to SQL Server 2012/2008R2
• Managed multiple SQL Server instances in Active/Active and Active/Passive clusters
• Installed and configured Async and Sync Mirroring for Production and DR environments
• Setup Log Shipping for production databases to carry out DR and failover.
• Had some experience in emerging interface protocols, Open API's, SAML.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle
• Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Creating, Modifying, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Created solid stored procedures for Backup and Recovery process
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Used DMV's for finding Index Fragmentation and Worst performing Queries.
• Provided 24 7 Production and Non- Production support for the databases and COTS Systems and application issues by developing MS SQL Server.
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Used Various different Transformation in SSIS for ETL packages
• Created extensive reports using SSRS Tabular, Matrix
• Performance tuning, and optimization of procedures and queries.
• Worked a lot on creating, designing databases and creating Views, Stored Procs and Triggers
• Worked hand in Hand with developers to carry out builds and releases.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases
• 24x7 support and on-call rotation schedule
• Proactive Monitoring, notifying and tuning database and application for optimal performance
• Perform database backup and restore, ensure data recovery, maintenance, data integrity and space requirements

Environment: SQL Server 2008 R2/2008, MS Visual Studio 2008/2010, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, SSRS, IIS 7.0, Query Analyzer, XSL, ASP.Net 2.0/4.0, C , Vb.NET, MS Visio, SQL Diagnostic Manager, Perfmon, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management Data Warehouse, Windows Server 2008 , Team Foundation Server, Unix, Power shell 2, Erwin , Foglight Performance Analysis for SQL Server, Spotlight on SQL Server Enterprise, ProClarity, SQL Compare 9.0.

Confidential

Sr SQL DBA

Responsibilities

• Extensively worked in column based databases OLTP OLAP environments that include Production, UAT and Development databases in SQL Server.
• Provided 24/7 production support on a rotating roster schedule.
• Suggested design and architecture structure for Databases and servers.
• Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
• Worked with Business Objects and SSRS.
• Experienced in Create and modifying SSRS reports.
• Experienced in Data Extraction, Transforming and Loading ETL using various tools such as Data Transformation Service DTS , SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Created daily, weekly and monthly SSRS dashboard reports for sales and profit analysis.
• Good exposure on Cluster environment servers, to failover/failback Automatic/Forced to the cluster nodes.
• Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server different geographical location and also carried out role changes and role reversals.
• Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development Production environments
• Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
• Supported production, System implementation and development of databases by installing and configuring.
• Designed and implemented high level backups/restore strategies for point in time recovery purposes based on the database environment. Used Idera SQL Safe backup tool to backup databases.
• Architected, designed and developed Emerging DaaS Database as a Service .
• Had some experience in emerging interface protocols, Open API's, SAML.
• Used Performance Monitor and SQL Server Profiler ran Trace to optimize long running queries and thereby improved the performance of the queries.
• Provided 24 7 Production and Non- Production support for the databases and COTS Systems and application issues by developing MS SQL Server.
• Worked with different teams Application, Active directory, Engineering QA to deploy projects to UAT Testing , Development, and Production environments.
• Migrating SQL Server 7.0 databases to SQL Server 2005 and 2008R2 and then 2012. Used SQL Server Upgrade Advisor to analyze SQL server 7.0 in the process of migration.
• Converted DTS Packages to SSIS Packages using DTS Package Migration Wizard.
• Created, Modified, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Proactively worked with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing indexes, adding or eliminating columns on existing indexes, and maintaining indexes/re-organizing tables, recommending SQL configuration changes.
• Created packages successfully using SSIS to transfer large volume of Data.
• Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.
• Database backups, transfers
• Database Upgrade, Migrations
• Space allocations support during Application upgrades
• Create/Modify/Refine SQL Server T-SQL procedures and triggers, etc.
• Assistance in conversion from other RDBMS platforms
• DBA Support for post-conversion
• DB performance monitoring analysis

Environment: SQL Server 2008R2/2008/2005/2000, MS Visual Studio, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, XSL, Vb.NET 2.0/3.5, MS Visio, Litespeed, Perfmon, Spotlight, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Management data warehouse, Windows Server 2008 R2/2008/2003/2000, Team Foundation Server, Unix, Power shell 2, Perl.

Confidential

Sr SQL DBA

Responsibilities:

• SQL Server Database Administrator responsible for the design, implementation, maintenance and repair of the organization's databases with over 3 TB of data.
• Performed index tuning for SQL databases to ensure optimal performance and response times.
• Completed migration of DTS to SSIS packages to incorporate latest technologies of SQL Server 2008, including data compression, partitioning and partition rotation for almost a billion rows of data within the data warehouse.
• SQL Server Developer deployed servers utilized by National Technical Support Services Performance Team as a SQL Server 2008 data warehouse exceeding 2 TB of critical processing statistics in order to monitor mainframe capacity and performance along with identifying processing anomalies.
• Experienced in Creating and modifying SSRS reports.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Supported production, System implementation and development of databases by installing and configuring.
• Had some experience in emerging interface protocols, Open API's, SAML.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Developed and/or optimized over 500 Stored Procedures, TSQL Queries, Indexes, Views, Functions, Triggers, scripts, DTS and SSIS Packages.
• Designed complex SSIS Packages in VS 2005 and C for SQL Server 2005 with transactions handling.
• Recommended database design, modeling, and code optimization.

Environment: SQL Server 2000/2005/2008R2, Windows Server 2003/2008/2008R2, BMC Remedy Suite, LiteSpeed, Object level recovery OLR , XSL, T-SQL, SSMS, SQL Profiler, Autosys, Cluster administrator, Precise I3 ,BCP, SSIS, Performance Monitor

Confidential

Sr SQL DBA

Responsibilities:

• Interface with business analysts and application developers to create and maintain physical data models based on the logical design
• Monitor and tune databases to ensure peak performance
• Design/implement backup and recovery solutions including SQLSafe as well as native SQL Server methods and tools.
• Built numerous SQL / TSQL quires, VBA modules, macros, tables, indexes, constraints, functions, subroutines, reports, forms, indexes, constraints, views, triggers, DTS / SQL Server Integration Services SSIS packages.
• Provide assistance to associates to resolve technical issues, document and implement best practices for the database environments.
• Supported production, System implementation and development of databases by installing and configuring.
• Establish and maintain standards, controls and procedures to ensure data integrity and security
• Perform capacity planning and projection for future growths.
• Created, Modified, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Provide on-call support on a rotation basis.
• Provided 24 7 Production and Non- Production support for the databases and COTS Systems and application issues by developing MS SQL Server.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Created, Developed, Modified and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Help with Data Modeling, Logical Physical Diagraming and translation to implementation
• Implement new database instances create indexes, performance tune queries.

Environment: SQL Server 2008R2/2008/2005/2000, MS Visual Studio 2008/2005, MS BI Dev. Studio, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer,C , Vb.NET, MS Visio, SQL Diagnostic Manager, Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, Resource Governor, Change Data capture, Windows Server 2008 , Team Foundation Server, Unix, Power shell 2, Erwin, Tivoli Workload Scheduler, OBIEE 10.1.3.3.2, AIX App server WebSphere 6.1 , 3DNS Automatic Fail over Tool ,IIS 6.0,Veritas Backup, ODBC for Teradata, Teradata, SQL Assistant 12.0, Litespeed, Teradata Client 13.10, SAS 9.2.

Confidential

SQL DBA

Responsibilities:

• Installation Configuration of SQL Server 2008/2005/2000 on Development, Test and Production environments
• Creation and Configuration of SQL Databases including striping VLDB's 600GB across multiple files and file groups Data files, Log files, Index files
• Security Administration adding logins, users, granting permissions thru roles, managing schemas on the SQL Server
• Created and modified various Parameterized Reports, Drill through Reports using SSRS 2008
• Creation Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Implementation of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers
• Migrated logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server 2000, 2005 on Development, Testing Production Environments for various mission critical applications. Upgrade DTS Packages to SSIS Packages.
• Supported production, System implementation and development of databases by installing and configuring.
• Experience in Designing and Data modeling logical/Physical Designs using ERWIN, Database Diagrams etc and Reverse/Forward engineer the data models
• Monitored database performance on tables using Index tuning Wizard and rebuilt indexes to reduce fragmentation using DBCC DBReindex, Indexdefrag, AlterIndex
• Development of automated daily, weekly and monthly system maintenance tasks.
• Created jobs, alerts and monitor, activity logs, error logs to capture and fix any possible errors
• Created Linked Servers across various data sources including SQL Servers, Oracle.
• Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation.
• Provided 24 7 Production and Non- Production support for the databases and COTS Systems and application issues by developing MS SQL Server.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and offsite storage.
• Configured Various Replication Types between servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005 Environment to Test the Software.
• Creating, Modifying, Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Developed, maintain, and support the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
• Extensively worked on DB Programming using T-SQL in developing stored procedures for generating various Reports using Sqlserver reporting services SSRS 2000/2005
• Monitoring Blockings and Proactively monitor Deadlocks and resolve them by setting up trace flags T1204,1205,T1222
• Worked with SQL Server Profiler, PSSDIAGs and other monitoring tools to generate traces and trouble shoot issues
• Involved in extensive in 24/7 production support and assisted end user in testing application functionality.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2000/2005 backend.

Environment: MS SQL Server 2008/2005/2000, Windows NT/2000, MS IIS 5.0, BizTalk 2000 Server, T-SQL,XML,LDAP, Active Directories ADSI , SSRS, SSIS, SSAS, SQL Litespeed, BMC Patrol, SpotLight, DBArtisan, SQL Compare and T-SQL, VBScript, JavaScript, DTS/SSIS, Backup Exec 8.6,VisualSourcesafe

Confidential

SQL DBA

Responsibilities:

• Involved in administration of MS-SQL Server version MS SQL 2000 / 2005 /2008 across different environments
• Performed security configuration, user administration tasks like managing users, roles, and profiles
• Performed Database backups operating system, flat file backups export/import
• Created DTS /SSIS Packages for data transformation.
• Used the MS Reporting services to created, schedule and publish the reports required
• Configured and used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Successfully Implement the 2 Node Active Passive clustering for two different production applications.
• Job Monitoring and making sure all jobs run successfully.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Experienced in Creating and modifying SSRS reports.
• Created Sub-reports, Drill-down reports, Matrix reports, Parameterized reports and Summary reports in SSRS 2008.
• Utilized VB.net in Script Task to check existing file in SSIS package
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in SSIS packages to extract data from column based database OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Provided 24 7 supports to SQL application developers in implementing the applications on production server and Non- production server.
• Established and documented a complete Disaster Recovery Plan for the Database servers
• Created development scripts, including rollback scripts, for all SQL Server changes
• Created Crystal Reports for Business Intelligence
• Tuned SQL Server performance using SQL Server Profiler and Execution Plans.
• Developed and enforced organizational SQL standards and best practices
• Evaluated new releases of operating systems and database management software DBMS and suggested processes for migrating to new releases
• Participated in application development process and code reviews of database objects

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, Compaq Proliant 6500, OLAP Server, T-SQL, Visio, SSRS, SSIS, Crystal Reports 8.0, Erwin 4.1.