SUMMARY:

• SQL Server DBA with 10+ years of IT experience with strong administration, implementation, and design using SQL Server 2016/2012/2008 R 2/2008/2005/2000
• Good Knowledge in installation, support, upgrade and configuration of MS SQL Server, 300+ servers, and databases in clustered and unclustered environments.
• Experience in implementing different types of Replication Models like Snapshot and Transactional.
• Hands on experience in Log shipping with SQL Server 2008/2005.T - SQL coding and testing: functions, views, triggers, cursors, and stored procedures.Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Management of users including creation/alteration, grant of system/DB roles and permissions on various database objects.
• Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Cursors, Triggers and more.
• Experience in creating packages, Scheduling Jobs, Sending Alerts using Database Mail.
• Experience in upgrading from MS SQL Server 2005 to MS SQL Server 2008 R2.
• Experience in using DBCC Utilities Checks Database Consistency.
• Supported VLDB in production environment; Proficient experience in table partition design and implementation including create, switch and merge partitions.
• Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS)
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, Troubles shooting, backup and restore procedures.
• Experience with Active Directory domain account and groups
• Experience in investigating and applying necessary SQL Server database patches and installing service packs.
• Documented disaster recovery plans and participated disaster recovery drills.
• Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2014/2012/2008/2005/2003 , Linux Ubuntu, Redhat, CentOS, Windows 8/7/Vista/XP/2000/98

Methodologies: Agile/Scrum, Light Agile Development(LAD), Waterfall, Iterative

SQL Server Tools: SQL Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system SPROCs

Database / DB Tools: Microsoft SQL Server, Oracle, MySQL, MS Access, PostgreSQL, Neo4J, Idera, Quest Software, MongoDB, Sybase, Visio, Er-Win, Foglight, Discovery Wizard, Redgate SQL Backup, Sharepoint Designer, xSQL Builder, MS Office, ER/Studio, SharePoint Farm Administration

Languages: Visual Basic, Transact SQL(T-SQL), DOS batch, PL/SQL, NoSQL, Powershell, HTML/CSS, XML, Java

PROFESSIONAL EXPERIENCE:

Confidential, Gaithersburg, MD

SQL Server Database Administrator

Responsibilities:

• Upgraded Worksite Database servers fromSQLServer2008 toSQLServer2008 R2.
• Established and maintained database policy and standards. Refreshed development and test databases, applied patches and service packs as required.
• Created Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
• Applied Service packs toSQLServerInstances.
• Configured and worked on Replication Server
• AnalyzedSQLServerenvironment and documented the gaps pertaining to Microsoft Best practices and implemented to remediate the gaps.
• Analyzed SQLServerMaintenance Jobs, documented them and updated Job plan to perform accurate Maintenance activity.
• Worked with Application teams in writingSQLStatements and generated reports as per their requirements.
• Worked with Different teams and converted their data from Excel and Access toSQLServerthrough SSIS packages.
• Analyzed current SSIS packages and improved its design for better performance.
• Analyzed Stored Procedures and modified codes for better performance.
• Provided support from Database and Application to have seamless availability.
• Prepared Database and Application support manual.
• Designed and refined indexing strategies; Planned and applied index defragging and statistic update policies.
• Installed, configured and supported SharePoint 2007/ 2010 Farms. Performed Farm and Site Collection administration, and coordinate various groups in IS, to implement changes, updates, and Site Collection creation.
• Worked on scheduling reports for different departments (Finance, Conflict, Leadership, HR)using XML code and generating reports in HTML format.

Environment: MicrosoftSQLServer2008R2 Enterprise Edition, Windows Server 2008 R2 Enterprise Edition, TransactSQL, NetApp, NAS/SAN, Microsoft Sharepoint, SQLCLR, .NET, Visio, Dell PowerEdge R900, SSIS. Idera SQL safe Manager, MS Access, Idera Diagnostic Manager, Idera Defrag Manager

Confidential, Baltimore, MD

Database Administrator

Responsibilities:

• Provided database related problem resolution support, including post implementation support
• Performed monthly server maintenance.
• Tuned the performance of the databases applying MS recommendations, using PerfMon andSQLProfiler
• Lead conference calls and coordinated with offshore team in India to migrate SSIS
• Participated in the implementation of COTS software in the test environment, if not maintained by the vendor packages and improved notification process.
• Addressed database integration issues including data migration, maintenance, capacity planning, and new application support.
• Trained Onsite Data Warehouse administrators in migration process through SSIS.
• Built Development Environment usingSQLServer2008, 2008 R2 on Windows 2008 as per Microsoft Recommended configurations.
• Planned, estimated, designed, and ensured customizations and integration components are designed to meet the business needs complying with Walden standards.
• Shared responsibility for the operation and maintenance of twenty-three SQL Server database servers and seventy Windows Servers
• Created and verified the databases and making sure it meets Microsoft Recommendations.
• Followed and implemented SQL Server security best practices such as separate and run SQL Server services under differentActiveDirectoryaccounts and used Kerberos authentication.
• Configure/optimize MS SQL servers connected to SAN Storage
• Documented of Data warehouse and provided support.
• Migrated few of the Datawarehouse process from access toSQLServerusing batch files,SQLCode, SSIS packages.

Environment: MicrosoftSQLServer2008R2, NetVault, Discovery Wizard, Foglight, Enterprise Manager, Dell PowerEdge R710, System Center Operation Manager (SCOM), xSQL Builder

Confidential, New Carrollton, MD

Senior Infrastructure Management Analyst

Responsibilities:

• Maintained Production database administration of highly critical and large application databases.
• Designed more complex data models, logical and physical databases, data dictionaries and schemas.
• Mentored the new hires and provided the knowledge transfers.
• Actively participated with customers in understanding their business process and suggested optimal database structure, practices and tools on specific projects, ensuredhigh customer satisfaction rates.
• Set up processes for regular backups and restore methods, and ensured the processes are followed.
• High emphasis on database security, permissions, user management and following bestindustry practices.
• Installing, upgrading and applying the latest service packs/hot fixes.
• Involved in High availability through RAID, Clustering, log-shipping, replication and disaster recoverystrategies.
• Monitored disk space utilization, CPU performance, I/O activities and automation ofmaintenance jobs usingSQLMail notification solutions.
• Migration/Moving database servers between different platforms/locations and setting upTest, QA and Production database environments.
• Comprehended the Service Level Agreement (SLA) commitment and met the standards.
• Documented all the database maintenance and administration activities to avoidsingle point of dependency and also assisted smooth knowledge transfers.
• Kept up to date with the latest database related technologies and suggested appropriate solutions considering the cost to the organization.
• Installed and managedSQLServer2005/2008 fail-over clustering.
• Supported approx 400SQLinstances and approx 2500 Databases
• Configured Mail setup inSQLServer2000.

Environment: SQL Server 2005/2008 Enterprise Edition, 1.2 TB database, Windows Server 2003, SQL Server 2008, Quest Spotlight, Quest Toad, Toad Data Modeler, HP Service Manager, Dell Poweredge M710

Confidential, Baltimore, MD

Senior SQL Server Database Administrator

Responsibilities:

• Performed closely with the project managers, system administrators, and development teams during the development, test, and launch phases of the software development and release cycle.
• Managed code and application deployments through the deployment cycle; Development to Quality Assurance to DTO to Production. Interacted with the appropriate IS Team, to support and troubleshoot various In-House and Third Party applications.
• Troubleshot and resolved issues relating to database integrity, database performance (deadlock, blocking,etc.), server performance (CPU, memory, I/O, network).
• Working on Client/Servertools likeSQLServerEnterprise Manager and Query Analyzer to administerSQLServer.
• Created Database Maintenance Planner for the Performance ofSQLServerwhich coversDatabase Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from DisasterRecovery.
• Planned and modified the permission issues in theserver.
• Fine tuned of database objects andserver
• Involved in Data migration (import & export - BCP) from Text toSQLServer.
• Created stored procedures for maintainingSQLServer, Wrote Stored Procedures forApplication Developers.
• Maintained DTS packages and SQL scripts for generating reports.
• MaintainedSQLScript for creation of Database Objec
• Created Physical Data Modelling using ER-Win

Environment: SQL Server Enterprise Manager, ER-Win, Query Analyzer, Benchmark Factory, Windows Server 2003/2008 Enterprise Edition, SQL Server 2008, Idera SQL safe Manager, Idera Diagnostic Manager, Microsoft Excel, SQL RedGate SQL Backup, Dell Power Edge 8450

Confidential, Owings Mills, MD

SQL Server Database Administrator

Responsibilities:

• Analyzed, design and build testing procedures that deliver the client’s goals and provide our clients with maximum value.
• Created Sarbanes-Oxley (SOX) standards for financial applications; achieved highest compliance level status for audits and prevented potential $25K monthly fines.
• Performed quarterly audits with IT security team of all systems under the scope of SOX.
• Performed yearly audits with external auditors (Ernst and Young) and successfully passed all database audits
• Performed database migration from Sun Solaris/ HP-UX to Redhat/CentOS reducing cost by over $1M.
• Consolidated 16 data servers to 4 servers; reduced hardware cost while providing high availability solutions.
• Upgradedserverfrom Sybase 12.5 to Sybase 15.0, Oracle 9i to Oracle 10g, replication 12.5 to 15.0 MSA.
• Solved hardware lease return delay issues by introducing disk mirroring; reduced downtime from 2-4 hours to 10 minutes
• Managed daily operations for over 20 servers including Oracle system using physical dataguard over Automatics Storage Management(ASM),SQLservers, Sybase data servers replicated using Managed Service Accounts(MSA)/Warm standby
• Supported development, quality assurance (QA) and production environments.
• Designed and implemented backup and disaster recovery plans.
• Troubleshot issues, monitored performance and tunedSQLqueries.
• Applied quarterly patches for Oracle, CPU, PSU.
• Set up physical dataguard, monitor latency on physical standby, recover database from failure.
• Provide 24x7 Production support and on-call.

Environment: 300+ MSSQLServers 2008/2005, 50K+ databases, over 30 PBytes. T-SQL, Perl, C#, ASP, .NET, Linux, SVC, SVN, Oracle, Sybase, Sun Solaris, Redhat, SQL LiteSpeed, HP Proliant BL460c Server, Designer/2000