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:
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.
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.
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.
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.
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
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 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.
Awesome mentor! ------------------- 81
Pretty good -------------------------- 7
Could've been better ----------------- 0
Needs improvement ----------------- 0
Unsatisfactory ------------------------ 0
July 9, 2018
Fantastic to work with. Great communication, accessibility, and technical skills. Highly recommend.
Oct 3, 2017
Solid experience in database development and support.
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.