SQL Server Database Administrator USA
(+01:00) English, Spanish, French, Vietnamese, Chinese
As a SQL Server DBA I am responsible for the implementation, configuration, maintenance, and performance of
critical SQL Server RDBMS systems. Hire me to perform following responsibilites for you:
Manage SQL Server databases
Configure and maintain database servers and processes
Monitor system's health and performance
Ensure high levels of performance, availability, sustainability and security
Analyze, solve, and correct issues in real time
Provide suggestions for solutions
Refine and automate regular processes, track issues, and document changes
Assist developers with query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
EMPLOYMENT
SQL Server Database Administrator
Brainsmiths Labs | Jan 2017 - Present
Replicated database from Oracle11g to SQL Server 2008 (Snapshot replication and Transactional replication).
Created a Linked Server to Oracle11g from SQL Server.
Created Active Directory with Security group with Table level permissions.
Responsible for maintenance of all the SQL Server and Oracle servers.
Created maintenance plan for regular scheduled Transaction log backup, Full backup (Separately in remote server), Check database, Reorganize index, Rebuild Index, Update Statistics and Cleanup task.
SQL Server Database Administrator
DockYard |
Feb 2016 - Jan 2017
Responsible for all the servers which are running in SQL platform (SQL Server 2005/ 2008)
Setup multiple Nodes (Active/ Passive) in SQL Servers to add clustering feature.
Manage SQL Server databases and Configure failover cluster.
Plan and modify SQL Server Permissions in quarterly basis.
Create databases and schedule backups (Transaction log backup, Differential backup and Full backup) with Recovery sessions (Simple or Full).
Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.
Setup Alerts, Notifications, Jobs, Job steps with automated Response solution schedules.
Frequently Monitor Connections, Locks and Database Performance.
Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.
Environment: SQL Server 2008, SQL Server 2005, Windows server 2005/2008.
SQL Server Database Administrator
DCSL Software |
Dec 2014 - Feb 2016
Responsible for 24x7 critical production support for 150 servers out of which 90 are production servers, remaining test and development servers.
Installation and Configuration of MS SQL Server 2008 on Windows 2008 Servers.
Installed service packs and security fix on production, test and development servers.
Configured multiple node failover cluster.
Performed Migration ofdata from SQL Server 2005 toSQL Server 2008Edition.
Designed the physical and logical data modeling design for development projects.
Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
SQL Server Database Administrator
LEAD Technologies, Inc |
Dec 2012 - Dec 2014
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Involved in cluster implementation
Implemented log shipping for hot stand by servers
Provided 24 X 7 dedicated support to all Production Environments
Scheduled the full backup, differential, transaction log backup of Database
Restored the Databases from the Disaster.
Planned and modified the permission issues in the server.
Transferred the data to homogenous and heterogeneous platforms using DTS utility.
Extensively worked on replication.
SQL Server Database Administrator
Fiserv |
Jan 2009 - Dec 2012
Over 2 year experience in MS SQL Server 2005 database development in enterprise environment. Strong troubleshooting and organizational skill.
Solid experience in database development and support. Database migration, SQL Server 2000 upgrade to SQL Server 2005.
Database performance tuning, capacity planning, and troubleshooting.
Expertise in RDBMS, data warehouse architecture and modeling, ETL and DTS/SSIS experience.
Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T- SQL
EXPERTISE
SQL Server
7 years
experience
Over 6 year experience in MS SQL Server 2005 database development in enterprise environment. Strong troubleshooting and organizational skill.
Solid experience in database development and support. Database migration, SQL Server 2000 upgrade to SQL Server 2005.
Developed and maintained MS Access database. Supported development of a speciation control documents for an MS Access
Project Management Database. Defined the periodic extraction and performed formatting of data from multiple sources and
laid out basic queries and reported required by the customer. Dictated the structure of the product so that it may
be configured and modified for other customers and for changing requirements.
Extensive knowledge of TSQL including transaction control, exception and error handling, row processing and declared
variables. Great hand on TSQL identifiers.
HTTP
9 years
experience
HTTP is the underlying protocol used by the World Wide Web and this protocol defines how messages are formatted and transmitted, and what actions Web servers and browsers should take in response to various commands.
REVIEWS
Average Rating
4.9
(88 ratings)
Awesome mentor! -------------------
81
Pretty good
--------------------------
7
Could've been better
-----------------
0
Needs improvement
-----------------
0
Unsatisfactory ------------------------
0
Rob Dayton
July 9, 2018
Fantastic to work with. Great communication, accessibility, and technical skills. Highly recommend.
Chris Hope
Oct 3, 2017
Solid experience in database development and support.
Bode
Dec 2, 2018
Professional and lots of experience behind. Thank you for your help
Robert!
SQL (structured query language) is a primary programming language that is used to retrieve information, information, and organize information in a database. It's dangerous for big businesses, and increasingly more for small and medium corporations. It is especially useful for corporations that deliver a product to end-users and, most of all, business-to-consumer companies.
