SUMMARY:

• Client - focused Database Administrator with over 5 years’ experience proactively working toward achieving high client satisfaction.
• An enthusiastic IT professional very much committed to maintaining and acquiring cutting edge technical skills and up-to-date industry knowledge.
• Deadline-focused with broad skill range including, 24/7 database Support of MS SQL Server in Production, Test, Development and Cluster Server Environments.
• Extensive knowledge and experience in log shipping, mirroring, replication, clustering and working knowledge on ALWAYS ON.

TECHNICAL SKILLS:

Database: 2008, 2008, 2008R2, 2012, 2014, Oracle PLM, PQM, Oracle E-business Suite

Operating Systems: Windows Server 2003, 2008, 2012, 2016

Tools: Management studio, Profiler, Integration Services (SSIS) (basic), Reporting Services (SSRS)(basic), Tuning Advisor, Visual Studio, MS office, Visio, Outlook, Excel, Access, Tableau, Commvault, Sentry Plan Explorer

Programming: T-SQL, C++ (Basic), HTML (Basic), T-SQL

WORK EXPERIENCE:

Confidential, Bohemia, NY

SQL Server DBA/Oracle Application Support

Responsibilities:

• Provided on-site dba support during business hours
• Coordinated with off shore dba teams to schedule and complete necessary tasks during off hours
• Acted as first point of contact and escalation for SQL level 1 alerts
• Implemented and configured log shipping as DR solution from Bohemia to Core site datacenter
• Added multiple secondary’s to existing SQL server
• Presented and implemented SQL comprehensive change tickets during weekly CAB meetings
• Reached out to application and server owners notifying of IT scheduled maintenance
• Created and configured Oracle linked servers to SQL
• Updated multiple servers to .Net framework in support of offsite teams new Delta Agent monitoring tool
• Handled various SQL administration tickets through Service Now
• Implemented critical changes in production (code deployment, server configuration changes, indexes)
• Provided recommendations such as MAXDOP, fill factors, creation of new indexes, maintenance plans for optimal performance
• Ensured backups were being taken through ComVault third party backup tool
• Applied monthly patches to MS Server 2005, 2008, 2012 OS systems
• Documented, maintained and updated the Nature’s Bounty SQL server environment through SharePoint.
• Manually synced users through Agile 9.3.2 form Nature’s Bounty Active directory as needed
• Assigned users to groups in Agile Product Lifecycle Management
• Provisioned responsibilities to users Oracle EBS
• Deployed XML reports to oracle through EBS
• Approved Inspirage tickets and provided maintenance window for bouncing of application
• Provided summary and update on tickets handled by on-shore and off-shore weekly to management
• Reached out to application owners and scheduled for the upgrade of various SQL servers (2008, 2008 R2) to SQL 2016 versions.

SQL Server DBA

Responsibilities:

• Reviewed and made recommendations for best high availability solutions such as log shipping, mirroring and failover clusters.
• Installed SQL 2008, 2008R2, 2012 and 2014
• Developed backup and recovery solutions to make sure SLA requirements are met
• Managed SQL server security including creating logins, granting server roles, database roles, assigning permissions, creating views and schemas
• Monitored SQL Server Error Logs, event viewer and Disk space growth
• Configured and implement Log Shipping process to DR site
• Implemented snapshot and transactional replication as per requirements
• Configured and maintained a two node fail over cluster for high availability
• Applied service patches to clustered nodes, primary and mirror partners and log shipping instances with multiple secondary
• Create maintenance plans for indexing and statistics update on weekends
• Configured and document Database Mirroring as a high availability solution on SQL Server 2008R2 and 2012.
• Create and deploy basic SSIS packages, transferred data to and from flat files and excel to SQL Server for web app
• Generated weekly, monthly reports using SSRS and deployed to report server
• Troubleshoot fragmented indexes that meet a certain threshold for better performance.
• Verified and maintained database backups, integrity checks, and scheduled jobs.
• Implemented Data Integrity by Using Constraints and Triggers
• Automate maintenance jobs and configuring their schedules
• Support performance tuning and monitored Memory, Processor, Disk I/O
• Identified Locking and blocking caused by long running queries
• Proactively identify problems, find root cause and perform tuning to ensure application performance.
• Solved tickets assigned from Remedy ticketing system
• Upgraded and migrated SQL 2008R2 instances to SQL 2012 using side by side method
• Wrote basic stored procedures to handle tasks
• Provided support to developers in solving development issues

Database Administrator

Responsibilities:

• Involved with team for the installation and configuration of SQL server 2008R2, 2012
• Worked with team in upgrading the database from MS SQL Server 2008 to 2008R2 and to 2012
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Tuning Advisor
• Created Schemas, Views and assigned granted permission to users
• Validated backups on a regular basis
• Applied service packs on MS SQL Server 2008R2 and 2012 instances
• Provided on call production support for the database and application issues
• Rebuilding the indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Generated weekly, monthly reports using SSRS and deployed to report server
• Involved in Index Analysis and Performance Tuning using tools like SQL Tuning Advisor
• Monitored workload to analyze performance using SQL Profiler
• Restored databases from backup in stage environment for testing
• Configure automated messaging services on sever for failed job using SQL DBmail
• Document all process for easy troubleshooting

Database Administrator

Responsibilities:

• Installed and Configured SQL Server 2008, 2008 R2
• Involved in upgrading SQL Server 2005 instances to SQL Server 2008 R2
• Involved in database design, database standards, T-SQL code reviews
• Managed Active/passive SQL Server Clusters
• Implemented Mirroring and Log Shipping for Disaster recovery
• Planned and Implemented complete backup strategy for Full, Differential and Log Backups
• Created SSIS packages, deployed them to various servers and scheduled them for execution
• Configured transactional and Peer to Peer replication and managed publications, articles
• Proactively involved in monitoring database Performance by monitoring Index fragmentation level and updating Statistics
• Automated most of the DBA Tasks and monitoring stats
• Responsible for SQL Server Edition upgrades and SQL Server patch management
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures
• Monitored event and server error logs for troubleshooting
• Supported the business 24/7, maintaining 99.999 uptimes depending on the application and business SLA requirements