We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

Sunnyvale, CA

SUMMARY

  • Over 7+ years of IT Experience in SQL Server database administration, system analysis, development and support of Microsoft SQL Server 2016/ 2014/2012/2008 R2/2008/2005 in development, test and production environments.
  • Experienced in installing SQL SERVER 2016/ 2014/2012/2008 R2/2008 updating with the hot fix and service packs on Physical/VM Ware Clustered and Standalone Environments.
  • Installed and configured SSIS, SSRS and Migrate database from SQL2008 to SQL2012/2014
  • Expertise in implementation of security models; windows users and groups, logins, roles, Trusted accounts, database authentication modes, users, database roles and permissions.
  • Recovered many databases to point in time or max possible data in many cases during database corrupted or accidentally dropped objects due to human error.
  • Experienced in database development for both OLTP (Batch Processing) & OLAP Systems using MSSQL Server 2005/2008/R2/2012.
  • Strong SQL Server developer skills including writing Transact - SQL Queries, stored procedures, user defined functions, views
  • Installed and maintained MS SQL Server 2005, Server 2008 on Windows 2003 Server.
  • Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version
  • Experienced in database development for both OLTP & OLAP Systems using MSSQL Server 2005/2008/R2/2012.
  • Installation and configuration of Oracle Golden Gate one-way and bi-directional.
  • Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, SSRS, log shipping, database mirroring, SQL mail, database mail.
  • Extensively used tools like SSMS, SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
  • Worked on database security, replication, SQL Clustering, Stand by server, DTS, SSIS, SSRS, log shipping, database mirroring, SQL mail, database mail.
  • Worked on SQL Server 2003 failover clustering on Windows 2003 server cluster.
  • Troubleshooting complex Golden Gate production issues including latency optimization, conflict resolution and Golden Gate configuration and optimization on RAC environment.
  • Good knowledge of SharePoint 2013 administration, deploying shared services, indexing, search, user profile creation and various application tasks.
  • Experience in writing SQL queries, stored procedures, triggers, functions, creating tables, views and indexes and eCommerce and ticketing industry experience, Waterfall & Agiledevelopment.
  • Experience in administrating, configuring and managing SAN, EMC storage for backups and disaster recovery, execution and testing at remote side.
  • Good knowledge at SQL Server 2008 enhanced features like filtered indexes, activity monitor, multi-server query, backup compression, resource governor, performance data collector, facets, and Transparent Data Encryption (TDE).
  • Monitoring event viewer, SQL error logs and log file viewer for software and hardware related errors.
  • Excellent knowledge of NoSQL databases like Cassandra and MongoDB.
  • Installation and updating the status of work items on daily basis at Team Foundation Server (TFS) and SharePoint 2013.
  • Installation, configuration and deployment of VMware products such as VMware Workstation, VMware converter, VMware View.
  • Developed reports and report processing logic using MS Reporting Services, created Asp. Net application to generate interactive UI based on reports metadata
  • Implemented the new SQL Server 2005 concepts like data partitioning, snapshot isolation, online restore, fast recovery, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV’s, DMF’s, SQLCMD, T-SQL debugger, CTE, secure sockets layer.
  • Worked on Deploying, managing, and operating scalable, highly available, and fault tolerant systems on Azure.
  • Use of SharePoint list source and destination for public SharePoint Web services.
  • Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert.
  • Experience in providing off hours production support for 24/7 over weekends on rotation basis.
  • Expertise in performance tuning, query optimization, client/server connectivity, improving efficiency of databases by performing database health check and database consistency by using DBCC Utilities, DMV’s and DMF’s, rebuilding indexes, updating statistics, partitioning tables, online indexes, scheduling maintenance tasks, avoiding locks, deadlocks, long running queries, blocking and expert in using trace flags.
  • Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
  • Expertise on business intelligence tools to create SSRS Reports, SSIS Packages and SSAS with OLAP. Migrating on premises SQL server database to Microsoft Azure.
  • Worked with XML files to configure .Net application, PowerShell code.
  • Experience in migrating all SQLServer Instances and databases to Microsoft Azure cloud, including all Apache and IIS Web Applications
  • Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio(SSMS) for Developers.
  • Experience in maintenance jobs to perform full, differential and transaction log backups using simple, bulk-logged and full recovery model for database backup, recovery solutions.

TECHNICAL SKILLS

Programming Languages: C, BS, SQL, TSQL, XML, HTML, ASP.NET, C#, Visual Studio 2010.

RDBMS: MS-SQL Server 2016/ 2014/2 R2/2005/Microsoft Access.

ETL Tools: SQL Server Integration Services (SSIS) 2012/2008/2008 R2/2005, DTS.

OLAP Tools: SQL Server Analysis Services (SSAS) 20012/2008/2008 R2/2005.

Reporting Tools: SQL Server Reporting Services (SSRS) 2008/2005, Crystal Reports.

Database Tools: SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, SharePoint 2013/2010/2007

Performance Tools: Erwin, Fog light, Idera, Spotlight, Tivoli, SCOM

Operating Systems: Windows Server 2003/2008/2008 R2/2012, Linux, Unix.

Backup tools: Idera, LightSpeed, Native Backup, PowerShell, Red Gate.

Microsoft Technologies: Visual Studio 2015/2013/2012/2010 , ASP.NET, SharePoint 2013/2010/2007

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr. SQL Server DBA

Responsibilities:

  • Created and maintained various databases for production, development and testing environments using SQLServer 2016/ 2014/2012/2008 R2/2005.
  • Used log shipping, on availability groups(AAG) and mirroring for synchronization of databases and transactional replication to achieve load balancing.
  • Proficiently used OS tools such as performance monitor, computer management, event viewer.
  • Worked with partitioning techniques to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Created and modified tables inSQLServeron various versions ofSQLserverfor multipleserverdatabases. Created new and modify existing stored procedures for selects, inserts, updates, deletes to use in .NETapplications.
  • Created T-SQL and database objects like tables, stored procedures, views, triggers, user defined datatypes and functions, planning the location of data, index, and transaction log files, CTE’s, on the disks.
  • Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
  • Configure troubleshoot all SQL Server components such as SQL server properties, database properties, table/column properties, SQL Server Agent Jobs, SSIS packages, database maintenance plans, error logs, alerts, and security.
  • Developed SQLServer Reports, SharePoint 2013 web Pages and SSIS packages to load table for reporting solutions.
  • Designed the business rules for data cleansing that are required by the staging OLAP and OLTP databases
  • Setting up SQL Azure Firewall and manage SQL Server Azure Databases.
  • Created logging forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
  • Designing implementing and trouble-shooting modern networks including TCP/IP DNS, DHCP switches routers.
  • Developed SharePoint 2007 Dashboard using the SSRS and performance point as the bridge.
  • Managed SSIS packages, stored procedures, jobs, and utilize Server-Side tracing to identify performance issues with deadlocks & other locking issues.
  • Experience in writing Transact-SQL Queries, stored procedures, user defined functions, views, triggers, indexes.
  • Implementation ofSharePoint2013 on Amazon Web Services using the AWS Management Console to provision the AWS infrastructure resources needed to run SaaS.
  • Worked on database issues and administration. Developed new applications for satellite communications network in C#.NETand ASP.NETand to maintain existing applications in VB.NETand C#.NET.
  • Worked and Set up, implemented Warm Standby Replication usingSybaseReplicationServer.
  • Implementation of high availability solutions with Oracle 10g RAC, physical and logical standby databases and replication usingGolden Gate.
  • Experience in SQL Server troubleshooting guidelines DNS/Authentication.
  • Setting up SQL Azure Firewall and manage SQL Server Azure Databases.
  • Used third party tool, lite speed, red gate to speed up backup operations.
  • Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
  • Developed project managed and delivered customer solutions forActiveDirectorymigrations.
  • Involved in creation of data warehouse cubes inSQLServer Analysis Service (SSAS)
  • Installed, Configured, migrated, upgraded, and maintained SQL Server 2014/2012/2008 R2/2008 database systems. Ensured database reliability and performance.
  • Configured and managed Nagios for monitoring over existing AWSCloud platform. Build Nagios monitors for new services being deployed.
  • Developed documentation for a .NetPlatform and translate the information into database requirements and specifications to develop multiple databases for a multi-client database.
  • Experience on Implementing and controlling the flow of data to and from Azure.
  • Designed and developed the backup and archiving, disaster recovery in AWS Cloud.
  • Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
  • Managing SQL server using PowerShell scripts.

Environment: SQLServer 2016/ 2014/2012/2008 R2/2005, SQL Server Reporting Services (SSRS), MS Azure, SQL Server Integration Services (SSIS), ETL, SharePoint Designer 2013/2010/2007 , AWS, Windows 2008, Windows 2012, T-SQL, Golden Gate, Red Gate, Visual Basic .NET1.0, DNS, ASP.NET, VM WARE, PowerShell, DFS, MS SQL Server Management Studio, Sybase, ERWIN and MSVISIO.

Confidential, Portland, OR

Sr. SQL Server DBA

Responsibilities:

  • Managed and administrated SQL SERVER 2014,2012,2008/2008R2, highly transitive production environment and Active Passive clustered environment.
  • Used log shipping and data mirroring for synchronization of database.
  • Implemented SQL Server 2008/2008R2 concepts like data partitioning, snapshot isolation, database mirroring, database snapshot, CTE, DDL triggers, try-catch blocks, online indexing, DMV’s, DMF’s, mail Setup, jobs, and alerts, SQLCMD and dedicated admin connection.
  • Expert inSQLdatabasehigh availability techniques like clustering and always-on high availability (HADR).
  • Develop and implement complex T-SQL, VBScript and PowerShell scripts for administration tasks, solving tickets on daily basis for production issues.
  • Extensively worked on trouble shooting and fine-tuning of databases for its performance.
  • Expertise on physical storage SAN configuration on different RAID levels.
  • Good knowledge and experience in dealing with relational database management systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers, cursors.
  • Installed SQL Azure instances and create databases on SQL Azure.
  • Worked with NoSQL MongoDB in working with collections and other database management tasks.
  • Created Data Center Environment by creating VMware clusters, adding ESX hosts in the clusters, and implemented HA and DRS.
  • Experience in troubleshoot and maintain RSA Archer GRC Platform and business applications in production, development and QA environments
  • For security management, creating logins, users and groups with appropriate permissions, granting privileges to users and groups, server and database auditing using server-side tracing, server audit specifications, event notifications and monitoring SQL Jobs.
  • Worked on data loading usingPL/SQL and SQL Loader calling UNIX Scripts to download and manipulate files
  • Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.
  • Experience in performance tuning by index defragmentation (rebuild, reorganize) optimizing execution plans, horizontal and vertical partitioning.
  • Creating database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.
  • Handled monthly database refresh in QA-Test environment for testing of new deployment and gave a good support to the developer and QA people.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexes updates.
  • Created tables and performed data imports and restores for successful migration. Script development and troubleshooting various security syncing scripts to new databases.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Deploy 2014 version SQL server database to a windows Azure Virtual Machine Wizard. Data and Log files are stored on Windows Azure storage (Cloud storage).
  • Extensive experience on working with Idera SQL Monitoring Tool.

Environment: Windows 2012, SQL Server 2014,2012,2008/2008R2, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), Java, RSA Archer, PL/SQL, SQL Server Analysis Services, MS Azure, Visual Studio 2012, VMware, T-SQL, ASP.Net 2.0, VB.Net, SQL Server Profiler, MS Access, Lite Speed, Idera.

Confidential, NY

Sr. SQL Server DBA

Responsibilities:

  • Installing, Configuring and Maintaining SQL server 2012/2008R2/2008/2005 on Active/Active Cluster with latest service packs, hot fixes.
  • Designed and implemented disaster recovery Procedures like log shipping, transactional replication, database mirroring.
  • Performed backups and restores, DBCC utilities, updated index statistics, monitor database and disk space.
  • Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2000/2005 to SQL Server 2008.
  • Installation ofserver and client software applications in a large environment
  • Installed and maintained 2-Node (Active-Passive) clustering.
  • Manages Mirrored databases & monitoring them appropriately worked on database migration from SQL server to Azure (Deploy DB to Windows Azure SQL Database).
  • Utilized the new features of 2008like merge statement and compressed backups.
  • Monitoring SQL server performance and to find deadlocks using SQL Server profiler.
  • Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.
  • Experienced in troubleshooting production servers and query tuning.
  • Configured transactional replication and log shipping with SQL Server Management Studio.
  • Used SSISto create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
  • Identifying performance bottlenecks (OS, Network, Database), tuning of both SQL statements and tuning of the RDBMS software, and recommend optimal performance recommendations.
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
  • Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
  • SQL logins, roles and authentication modes are created to different users for security of data.
  • Database objects migration - transfer and synchronize database schemas, triggers, stored procedures, indexes, SQL Server agent jobs amongst different environments using SQL compare.

Environment: TSQL, MS SQL SERVER 2012/2008R2/2008/2005, SSRS, MS Azure, Query Analyzer,ETL, Visual Studio 2010, VB.NET, C#, Windows Server 2008, SSIS, SSRS, SAN, database engine tuning advisor.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Installed and configured SQL Server 2012/2008R2/2005.
  • Extensively worked on log shipping and database mirroring for 2005 and 2000 production servers and SQL server 2005 security audit
  • Hardware requirements and storage capacity planning for Development, Testing, QA, Staging and Production for scalable database growth and performance.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags, activity monitor.
  • Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and SQL to Oracle using SSMS.
  • Implemented T-SQL features in SQL Server 2008 by Data partitioning, Error handling through try-catch statement, common table expression(CTE), pivot.
  • Used DMV’s, DMF’s for Identifying missing indexes and Index usage stats, fragmentation levels of Indexes for query/stored procedures tuning.
  • Involved in various transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
  • Retrieved data from partition of the cube from data ware house (OLAP) using the BIDS.
  • Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements.

Environment: Windows 2003, MS SQL Server 2012/2008R2/2005, SQL Server Integration Services (SSIS), VMware, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BIDS, Upgrade Advisor.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Installed SQL Server 2008/2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
  • Implemented high availability concepts like database mirroring and transactional replication as a part of disaster recovery plan.
  • Managed all publisher, distributor and subscriber database environments for the replication
  • Testing backups to ensure business recovery time objective(RTO).
  • Performing query plans and making sure each query is using appropriate indexes.
  • Checking performance tuning, indexing, query optimization.
  • Implement and manage the clustering environment like Active/Passive and Active/Active.
  • Expert in using and implementing DMV's, DMF's, data partitioning, DDL triggers, mirroring, online indexing and managed error handling using try catch Block.
  • Involved in analysis, development and maintenance of backup plan, disaster recovery plan, procedures and strategies using maintenance plans.
  • Designed T-SQL scripts to identify long running queries and blocking sessions.
  • Developed Backup and Restore scripts for SQL Server 2005.

Environment: MS SQL Server 2008/2005 Windows 2008/2003, Performance tuning, query optimization, T-SQL, RTO, SAN, DTS VB Script, Query Analyzer, Enterprise Manager.

Confidential

SQL Server Developer

Responsibilities:

  • Installation and configuration of SQL Server 2000/2005 on Window 2000/2003.
  • Implemented database mirroring on MS SQL SERVER 2005.
  • Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • Worked on migration and maintenance of data using various utilities like DTS, export, import and attach/detach data migration tools.
  • Developing stored procedures, DDL/DML triggers, views and adding/changing tables for data load and transformation and data extraction.
  • Extensively involved in Data Warehouse(OLAP) design and administration.
  • Views, User defined data types, functions, Cursors and Indexes using T-SQL.
  • Backed up databases and restored databases using Lite Speed.

Environment: MS SQL server 2000/2005, windows server 2000/2003, Visual Studio, Data Warehouse, Lite Speed, Oracle 9i, 10g, 11g, Microsoft Access.

Hire Now