It Analyst Sql Dba & Mysql Dba Resume
4.00/5 (Submit Your Rating)
Austin, TexaS
PROFESSIONAL SUMMARY:
- 6 years of experience in SQL Database Administration and Development for very large and complex databases in SQL Server 2016/2014/2012/2008 R2/2005/2000 on cluster and standalone environments, databases ranging from GB’S to TB’S in size.
- Microsoft certified Professional in Administering Microsoft SQL server 2012 Databases.
- Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005, 2008R2, 2012, 2014 and 2016 version.
- Experience in Upgrading to SQL Server 2005/2008 R 2/2012/2014/2016 (In place Up gradation and Side by side Up gradation) based on application compatibility and fixing the orphan users.
- Extensive Experience in Migrating huge databases from SQL server R2 and 2008R2 to 2012 and higher versions based on application compatibility.
- Administration and Maintenance of more than 600 huge and complex client databases in SQL server 2000, 2005, 2008R2, 2012, 2014 and 2016 versions.
- Experience in working on Very Large Databases (VLDB) over 5 TB for Confidential .
- Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.
- Strong experience on identifying the logins with super privileges and controlling the access as per the requirement and mitigating the risks for unauthorized activities.
- Strong experience on understanding and creating the server level and data base level roles as per business requirement.
- Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans and Database Mail Configuration.
- Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.
- Responsible for performance tuning of stored procedures using SQL Profiler and Database Tuning wizard.
- Good experience with implementing High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON.
- Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.
- Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganize based on fragmentation.
- Knowledge on T - SQL Programming.
- Experience on third party backup tool i.e. commvault.
- Provided 24/7 database maintenance and production support.
- Strong experience on indexing strategies, Creating and tuning the indexes based on the workloads.
- Strong experience on identifying and troubleshooting the database health, integrity checks and fixing them.
- Strong working knowledge with system databases like Master, Model, Temp, MSDB and maintaining them for the smooth execution.
- Experience on recovering the corrupted master database files.
- Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganization based on fragmentation.
- Experience on installing SQL Server Integration and Reporting Services (SSIS & SSRS) and configuration on both standalone and Clustered Environments.
- Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
- Strong experience in ETL Application using SSIS with various source like flat files, excel.
- 3 years of Experience in Installation, Configuration, Maintenance and Administration of MySQL Linux server (5.1 to 5.6).
- Responded to database problems and issues relating to applications and systems in MySQL.
- Maintained system documentation relating to application architecture and technical platforms in MySQL.
- Experience in configuring Replication in MySQL and resolving the related issues.
- Good interpersonal skills, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
PROFESSIONAL SUMMARY:
Confidential, Austin, Texas
Databases: SQL Server 2000, 2005, 2008 R2, 2012, 2014 and 2016, Windows, SQL Profiler, SQL agent, Database Migrations, Availability Group, DB Mirroring, Service Central Ticketing tool, MS SQL Server Reporting Services (SSRS), MySQL Replication
IT Analyst SQL DBA & MySQL DBA
Responsibilities:
- Administration of large databases in SQL Server 2005 and 2008 R2, 2012 and 2014.
- Routine DBA jobs like Backups and Restores.
- Worked on Database Engine Tuning.
- Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.
- Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
- Managing SQL server using PowerShell scripts.
- Installation and configuration of SQL server 2005, 2008R2, 2012, 2014 and 2016.
- Upgrading SQL Server 2005 to SQL Server 2008R2 or 2012/2014 (In-Place upgrade / Side by side upgrade)
- Expertise in implementing Database Mirroring and failover cluster on SQL Server 2005, 2008 and 2012 for high availability.
- Making use of ticketing tool Service Central to monitor the incident and requests received from the client or user and solving them following the ITIL process.
- Developing MS SQL Server Databases as per the client requirements.
- Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
- Ran DBCC and fixed data corruption in application databases.
- Implementation of Backup and Recovery strategies
- Working on Disk free space and Log files full issues
- Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganization based on fragmentation.
- Experience on refreshing the database from production to dev, QA, staging environments, fixing the orphan users
- Configuring SQL Server Agent-Events, Jobs, Alerts, maintenance plans and Operators
- Providing Support on Weekends and attending weekly calls/meetings
- Configuring and managing High Availability solutions (Clustering, Mirroring, Log shipping, Replication (Transactional)) and Always ON
- Solving problems related to database Performance issues.
- Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build
- Monitoring the Log Space for successful execution of all the specified jobs.
- Providing support to SAP application databases which carry huge database sizes.
Confidential
Environment: SQL Server 2000/2005/2008 Enterprise, Query Analyzer, T-SQL, DB migrations
Databases: SQL Server 2000, 2005, 2008 R2 and 2012
Senior Technical Associate - SQL Database Administrator
Responsibilities:
- Administration of large and complex databases in SQL Server 2000, 2005, 2008R2 and 2012.
- Installation and configuration of SQL server 2008R2 and 2012 databases.
- Designed and Developing MS SQL Server Databases
- Debugging and Writing Stored Procedures
- Maintenance and Planning of Jobs.
- Performance Tuning, Query Optimization
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
- Created Logins and Roles with appropriate permissions.
- Created and Maintained Database Maintenance Plans.
- Experience on T-SQL Programming
- Implementation of Backup and Recovery strategies as per RTO and RPO.
- Worked on Disk free space issues.
- Responsible for performance tuning of stored procedures using SQL Profiler and Database Tuning wizard.
- Worked on Log files full issues.
- Configured SQL Server Agent-Events, Jobs, Alerts and Operators.
- Provided Support on Weekends and attending weekly calls/meetings.
- Configured and managed High Availability solutions (Clustering, Mirroring, Log shipping, Replication (Transactional))
- Solved problems related to database Performance issues.
- Monitored the Log Space for successful execution of all the specified jobs.
- Developed of internal tools using VB.Net and C# with SQL server 2008R2 as backend.