ROBERT

Average Rating

4.6

(88 ratings)

ROBERT

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
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.

MS Access
MS Access 2 years experience

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.

JavaScript
JavaScript 7 years experience

Solid experience in Javascript, JSON, and Ajax, and knowledge of javascript framework such as JQuery, DOJO, etc

TSQL
TSQL 3 years experience

Extensive knowledge of TSQL including transaction control, exception and error handling, row processing and declared variables. Great hand on TSQL identifiers.

HTTP
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

Rob Dayton

July 9, 2018

Fantastic to work with. Great communication, accessibility, and technical skills. Highly recommend.

Chris Hope

Chris Hope

Oct 3, 2017

Solid experience in database development and support.

Bode

Bode

Dec 2, 2018

Professional and lots of experience behind. Thank you for your help Robert!

POSTS

Why To Use MS SQL Server

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.