Occupation:Database Administrator |
Location:Atlanta, GA |
Education Level:Bachelor |
Will Relocate:YES |
Description
Skills Summary: * Responsible for troubleshooting and problem solving of SQL database Servers. * Experience writing, debugging, and tuning Transactional SQL, and stored procedures. * Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies. * Average experience in networking configuration * Experienced in setting up partially contained databases using SQL server 2012. * Experienced in deploying SQL server 2012 cluster solutions * Responsible for improvement and maintenance of the databases to include release rollout and upgrades. * SQL Server Replication * Experience managing multiple MS SQL 2000, 2005, 2008, 2008r2, 2012 RDBMS on web-based, transactions. * Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers. * Maintenance and tuning of the databases and replication. * Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles. * Provide SQL Server database physical model creation and implementation (data type, indexing, and table design). * Experience working with merge and transactional replication. * Management of multi-terabyte production clustered systems using ACTIVE-PASSIVE Clustering. * Experience with SQL Server 2000, 2005, 2008, 2008r2 and 2012 on Windows NT, Server 2003, 2008 and 2008r2. * Proficient in performance of SQL Server software new installation and upgrades. * Proficient in Backup/recovery strategies implementation. * Proficient in maintaining and supporting SQL Server Transactional and merge replication. * Expert in reviewing overall physical database structure for overall stability * Proficient in use of tools like SQL Server profiler and Windows performance monitor. * Experience with implementing Database Disaster Recovery and Planning * Proficient in logical and physical database modeling. Experienced with the design, implementation, and administration of SQL Server database solutions. * Have good understanding of Disk and Server configuration for SQL Server. * Experience with network connection tuning using SQL Server 2005. * Development database support (SQL, T-SQL tuning, Application tuning etc). * Proficient in SQL Server 2005, 2008 and 2008r2 database cloning. . * Proficient in writing and optimizing T-SQL codes and stored procedures. * Expert in Data Loading and ETL. * Experience configuring and supporting SSRS for SQL server 2005 and 2008r2. * Experience with monitoring and troubleshooting 24x7 operations. * Extensive knowledge in Microsoft SQL Server databases, as well as SSIS, DTS packages, T-SQL, performance tuning, database design and data warehousing. * Experience with cross-platform database migration and database instance consolidation.
Accomplishments
Highlights:
Keywords
