Sql Server Support Engineer Irving, Tx
SUMMARY:
- Extensive working experience in Government Client and various industries Automobile, Financial, Energy Sector, Arts Performing and Healthcare industry, including designing, implementing, maintaining and documenting complex database applications.
- Experience with software development life cycle (SDLC) and project methodologies.
- Managed a major Hardware Upgrade / Database Migration.
- Performed Capacity Planning, data modeling and Logical/Physical database Design.
- Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Log Shipping, Replication, Mirroring and Always - on Availability Group).
- Experience in installing and configuring SQL Server 2012/2008 R 2/2008/2005/2000 clusters in Active/Active and Active/Passive.
- Experience with SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005 installation, configuration, SSIS, SSRS, MOSS 2007 and administration.
- Involved in updating Windows Patches and SQL Server Patches on different versions of Windows Operating System and SQL Server.
- Involved in migrating databases from SQL Server 2000 to SQL Server 2005, 2008 and from SQL 2005 to 2008, 2008 R2 (Side by Side), 2008, 2008 R2 to 2012 and 2014.
- Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, Performance Dashboard, BIDS, DTS, SSRS, SSIS and SSDT.
- Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, SQL Server Log shipping and SQL Server clustering.
- Experience in Replication - Transactional, Peer-to-Peer, Snapshot and extensive knowledge in Merge replication.
- Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
- Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2014/2012/2008 R2/2005/2000 with T-SQL.
- Experience in working on Database level encryption and Data level encryption.
- Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Errors, and Event Handling.
- Experienced in writing T-SQL (DDL, DML, and DCL). Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
- Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks & Blocking.
- Managed Amazon web services(AWS) in different data centers US East (N. Virginia) and US West (Oregon)
- Experience in AWS design and Administration with knowledge in RDS and EC2.
- Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
- Proficient with database backup and recovery models.
- Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
- Having experience in third party tools LiteSpeed, Idera, RedGate Foglight and Spotlight.
- Installed and Configured TortoiseSVN and pulled the files from SVN to our local folders.
- Download the production going scripts from AHP and prepared the implementation instructions.
- Managed GitHub and GIT Bash tools, pull the folders and SQL files from GIT source.
- Worked on Jenkins to download SQL Scripts using Token number and prepared the implementation instructions.
- High level plan for securing all the databases and better control on all SQL Servers.
- Involved in creation of linked servers using remote user account.
- Industry working experience in SQL Server and Oracle database management, maintenance, and troubleshooting.
- Worked on VMware machines.
TECHNICAL SKILLS:
Relational Databases: SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000/7.0, Oracle 9i, Oracle 8.0, MS Access 2000, DB2, SQL*PLUS
Operating Systems: UNIX, Windows Server 2012, 2008 and 2003, Windows Server 2000, Windows NT 4.0, Windows XP
Languages: C, C++, PL/SQL, Java, VB 6.0 and T-SQL
Web Technologies: ASP.NET, VB.NET, Web Services, HTML, DHTML, Java Script, VBScript, IIS 4.0, IIS 5.0, Application Server
Other Tools: Crystal Reports, Test Director 7.0/7.5/8.0, PVCS Tracker 7.0,Rational Clear Quest
PROFESSIONAL EXPERIENCE:
Confidential, Irving, Tx
SQL Server Support Engineer
Responsibilities:
- Experience in supporting of SQL Server 2016/2014/2012 and all editions of SQL Server.
- Assign cases from MSSolve, complete the SLA and Send the scope to the Customer.
- Extensive knowledge in Always-on Availability group and their troubleshooting.
- Help customer to configure always-on availability group on Multi-site subnet.
- Support SQL Server connectivity issues which are hosting by AWS and Azure cloud based technologies.
- Answer to customer questions in all the topics like Always-on Availability, clustering, replication etc.
- Support customer if there are any database corruption and help them to recover the database.
- Provide Microsoft documents on how to setup SQL Server, Always-on, Clustering, Replication and any cases that comes up.
- Help troubleshooting Service Pack/Patches/Bug installation issue due to missing files or any other recommendation.
- Run SDP package to capture SQL Server Logs, Error logs and event logs.
- Experience in running PSSDIAG, capture the server information, understand the customer issue and provided solutions to them.
- Provide recommendation on capacity planning and improve the performance of the Server.
- Recover the always-on availability group databases when they are not in Synchronous mode.
- Support customer in setting up log shipping to DR site and troubleshoot the issue he is having.
- Customer is having BizTalk job failure due to un-trusted domain, help them to resolve the issue.
Confidential, Plano, TX
Sr SQL Server Administrator
Responsibilities:- Experience in installation of SQL Server 2016/2014/2012 Enterprise and Standard Edition in newer environments.
- Extensive knowledge about 2016 new features like Always Encryptions, Dynamic Data Masking, Multiple Tempdb files during the time of installation, Row Level Security and Query store feature, etc.
- Worked on supporting multiple applications like OPUS/Empower, CDS, SDS and MSP.
- Extensive experience in working on high availability and disaster recovery plans like Mirroring, Replication and Always-on Availability Group.
- Worked on creating databases for developers and giving them appropriate permission on dev environment.
- Apply latest services packs on all Dev, QA, UAT and Production servers.
- Working on Data Center Migration of moving all databases from ING to COF domain.
- Reviewing SQL scripts provided by developer execute them in QA and UAT; update CO with Implementation instruction for production deployment.
- Worked on Monthly Sprint release that comes every first week of the month.
- Involved in Weekly Production release deployments like OCR\BAU\EMR on weekly basis.
- Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
- Involved in monitoring the SQL Server Performance issues using third party tools like Diagnostic Manager and Performance Analysis.
- Daily task to verify the backup jobs and maintenance jobs are running fine.
- For Every sprint I have prepared DevRoot, QARoot and QA1Root database for SQL Servers.
- Compare using RedGate tool from Prod to UAT and UAT to QA sync any differences at data level and object level, this is monthly maintenance to Sync all environments.
- Involved in User requested tickets to execute the scripts both DML and DDL operations on QA and Production environment.
- Created complex SQL views and stored procedures to join multiple tables for contract data interface files.
- Configured and maintained MySQL database servers.
- Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySql DBA.
- Prepared automation scripts and developed PostgreSQL database architecture.
- Implemented migration tasks from Oracle apps to PostgreSQL databases.
- Designed, developed and maintained PostgreSQL database architecture.
- Prepared and updated scripts for various administrative tasks.
- Maintained documentation of scripts in all source repositories.
- Developed scripts for database monitoring and tuning procedures.
- Worked on daily compare with QARoot and DevRoot to local database, if any changes occurred revert the changes to QARoot settings.
- Involved in designing and deploying a multitude application utilizing almost all of the AWS stack (including EC2, Route53, S3, RDS Dyanamo DB, SNS, SQS, IAM) focusing on high-availability, faulty tolerance, and auto-scaling.
- Managed databases on RDS and EC2 environment.
- Managed Amazon web services(AWS) in different data centers US East (N.Virginia) and US West (Oregon)
- Migrated the databases, logins and jobs from On-premises servers to RDS AWS.
- Designed, Implemented and Migrated databases to AWS.
- Analyzing Your Database Workload on an Amazon RDS DB Instance with SQL Server Tuning Advisor.
- Determining a Recovery Model for Your Microsoft SQL Server Database.
- Dropping a Microsoft SQL Server Database in a Multi-AZ with Mirroring Deployment.
- Renaming a Microsoft SQL Server Database in a Multi-AZ with Mirroring Deployment.
- Resetting the db owner Role Password.
- Restoring License-Terminated DB Instances.
- Transitioning a Microsoft SQL Server Database from OFFLINE to ONLINE.
- Working with Microsoft SQL Server Logs.
- Installed and Configured TortoiseSVN and pulled the SQL files from SVN to our local folders.
- Download the production going scripts from AHP and prepared the implementation instructions.
- Managed GitHub and GIT Bash tools, pull the folders and SQL files from GIT source.
- Worked on Jenkins to download SQL Scripts using Token number and prepared the implementation instructions.
- Prepared Self-Paced Cassandra through Datastax.
- Completed the courses of “Introduction to Apache Cassandra” and “DS201: Datastax Enterprise Foundations of Apache Cassandra”
- Created tables under the KeySpaces using CQL Fundamentals, with clustering columns, Primary keys, partition keys.
- Import/Export data from CSV using CQL statements.
- Extensive on Cassandra features like Replication factor, Ring, peer to peer, Vnodes, gossip, snitch, consistency and Hinted Handoff.
- Worked on third party tools like AnthilPro, Kanban and RegGate Tool to support daily work.
Confidential, Baltimore, MD
Sr SQL Server Administrator
Responsibilities:- Experience in installation of SQL Server 2012 and SQL Server 2014 in newer environments.
- Configured Always-On Availability Groups (SQL Server) on both 2012 and 2014.
- Experience on supporting Active/Passive clustering environment.
- Worked on supporting multiple applications like Moxy, APX, Galileo, CRD, Salerio and Automate.
- Experience in setting up Disaster recovery and High availability plan on Always-on Availability group.
- Experience in applying SQL Server Service Packs to the latest version 2008 R2 and 2012 servers.
- Experience in working on VMWare and Stand-alone servers.
- Extensive experience in setting up and troubleshooting Mirroring, Log shipping and transactional replication.
- Create Databases on SQL AZURE.
- Setting up SQL Azure Firewall
- Create, manage SQL Server AZURE Databases
- Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
- Daily task to verify the backup jobs using Symantec backup exec, Native backups and troubleshoot them if the jobs are failed.
- Assign Support Request Management tickets and complete the work as requested.
- Worked on multiple internal projects to support application team to fulfill their needs.
- Involved in monitoring the SQL Server performance issues using third party tools like Spotlight and Performance Analysis.
- Worked on Production servers and troubleshooting them as needed.
Confidential, Gaithersburg, MD
Sr SQL Server Administrator
Responsibilities:
- Experience in installation of SQL Server 2008 R2 and SQL Server 2012 in newer environments.
- Experience in applying SQL Server Service Packs to the latest version on 2008, 2008 R2 and 2012 servers.
- Worked on migrating SQL Server Databases from SQL 2005, 2008 R2 to SQL 2012 version.
- Successfully migrated around 50 databases to SQL 2012 version.
- Experience on supporting Active/Active clustering environment.
- Experience in working on VMWare and Stand-alone servers.
- Extensive experience in setting up Snapshot, Log shipping, Transactional and Merge replication.
- Worked on setting up mirroring from internal domain to external domain.
- Daily task to verify the backup jobs and troubleshoot them if the jobs are failed.
- Assign Service-now tickets and complete the work as requested.
- Worked on decommissioning the databases which are not required using service-now tickets, also filling up the decommissioning request form.
- Worked on multiple internal projects to support application team to fulfill their needs.
- Worked on collecting all application users and their information are uploaded to SQLInventory database for immediate contacts.
- Involved in monitoring the SQL Server performance issues using third party tools like Foglight and Performance Analysis.
- Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
- Worked on requesting firewall ports open from external domain to internal domain.
- Worked on data compare using TOAD for SQL.
- Assign Service-now tickets and complete the work as requested.
- Worked on Production servers and troubleshooting them as needed.
- Involved with users and executing the scripts on Production environment.
- 24/7 on call support.
Confidential, New York, NY
Sr SQL Server Administrator
Responsibilities:
- Involved in supporting high availability concepts like Clustering, Mirroring, Replication and log shipping.
- Experience in installation of SQL Server 2008 R2 and SQL Server 2012 in newer environments.
- Experience in applying SQL Server Service Packs to the latest version on 2008, 2008 R2 and 2012 servers.
- Experience in working on VMWare and Stand-alone servers.
- Involved in troubleshooting the performance issues like memory pressure, High CPU utilizations and Disk IO’s at SQL Server level.
- Extensive experience in setting replication, mirroring and log shipping.
- Involved in Capacity Planning, data modeling and Logical/Physical database Designs.
- Daily task to verify the backup jobs and maintenance jobs are running fine.
- Worked on space reports for all servers and request the space if it is required, to maintain below 70% of space occupied.
- Experience in generating the reports and running scripts using central management servers.
- Worked on setting-up the multi-server administration to manage target servers from centralized server.
- Scheduled the Maintenance jobs, Native backup jobs and “shrink transactional log file” jobs from Multi-Server Jobs.
- Assign Service-now tickets and complete the work as requested.
- Experience in handling multiple internal projects at a time and implemented them successfully.
- Worked on Critical Business requirements to execute SQL scripts on Production servers using emergency change request.
- Involved in User requested tickets to execute the scripts both DML and DDL operations on UAT and Production environment.
- Worked on privilege tickets to provide read, write and execute permissions on windows and SQL Logins.
- Maintain Azure SQL databases using the Elastic Database tools.
- Moved data from a multi-tenant database to a single-tenant database using Elastic database tools.
- Maintain Elastic database jobs, queries and run transactions that span several databases in Azure SQL database.
- Experience in decommissioning the old servers and databases which are not required using service-now tickets, also filling up the decommissioning request form.
- Worked on requesting Firewall ports to be open to connect SQL Server machines.
- Extensive experience in Idera backup tool which has policy based schedules.
- Involved in monitoring the SQL Server performance issues using third party tools like Foglight and Performance Analysis.
- Also, have experience in using performance dashboard reports in SQL Server.
- Experience in supporting DR servers to confirm that servers are functioning properly.
- 24/7 on call support.