*Required Experience: 9 years // Need LinkedIn URL // Visa copy*
*Position: SQL DBA /Designer* *Location: Atlanta, GA* *Duration: 6 Months+* *Max Rate: $55/hr on C2C* Scope of Position: The Senior DBA is responsible for managing and supporting, integration, performance tuning and optimization, integrity and security of all data warehouse database environments. The Senior DBA is also responsible for supporting database application deployments in the production EDW environments. Primary Responsibilities: Senior DBA reports to Data Management Manager to: · Develop, test, deploy and maintain comprehensive and highly reliable database backup and restore procedures. · Monitor database performance, backup, and recovery. · Support the growth of a SQL Server environment designed to support internal systems. · Create and maintain automated repeatable maintenance processes for optimal database performance and reliability. · Server and network design, database tuning, and optimization. · Work with technology support resources, system engineers, and developers to ensure database reliability, health, and performance. · Provide documentation and support for database configurations, data structures, and other components. · Enforce that data security, appropriate access are established and tested. · Monitor and tune SQL servers and SQL jobs for enhanced performance and operations. · Analyze and troubleshoot SQL server production issues related to performance, errors, and/or capacity. · Install, upgrade, configure and maintain SQL servers in a virtualized Windows environment. · Plan capacity and monitor database growth. · Periodically review user access requirements, monitor and manage SQL server security, logins, roles and user access. · Design, build and rebuild database indexes for optimal efficiency. · Develop, test, deploy and maintain database routines/scripts for administering all SQL server production databases for high availability, reliability and optimal performance. · Write highly-efficient SQL statements that perform well against large databases. · Develop ETL processes to import and export data between databases and other external sources. · Maintain and support data loads and data transformation processes. · Design, test and document data recovery and disaster recovery strategies. · Conduct database schema, T-SQL scripts, code review and assure code complies with coding standards prior to moving them from test or QA to production. · Work with application developers to know how front end applications work and participate in performance testing results. · Critically review and propose enhancements to the Company’s database environment. · Write database technical documentation, including database security standards, procedures and definitions for the data dictionary. · Other duties as assigned. *JOB REQUIREMENTS* · Strong knowledge of SQL Server architecture and environment. · Experience designing and performance tuning SQL Server databases. · Thorough understanding of database and data warehouse designs. · Experience with database and T-SQL optimization, profiling, troubleshooting, capacity planning, scaling & availability; storage management, database backups/restores. · Strong SQL Server 2012/2014 experience Integration Services, T-SQL, and programming stored procedures, triggers, and functions. · Capable of developing in Microsoft MDS · Strong Knowledge of SSIS technology and developing/supporting ETL packages. · Knowledge of Spotlight DBA tools is a plus. · Strong knowledge of relational data modeling using Erwin and enterprise system development and integration · Ability to work with others in a constructive and collaborative manner · Ability to think critically; to recognize and anticipate a problem (technical, operational, process, organizational) and to identify and implement or communicate the best solution in a timely manner. · Excellent communication skills with entire team (developers, business analysts, project managers, system engineers, etc.) · Understanding of external dependencies and their effect on database design. · Proficiency in Word, Excel, PowerPoint, Access. · Candidate must be self-motivated, possess excellent verbal and written communication skills. · Ability to work independently and in a collaborative team environment. · Strong work ethic, excellent interpersonal skills and a positive attitude. · Ability to manage own work, multi-task and prioritize tasks. · Ability to work extended hours and weekends on occasion. · Maintain knowledge of current and future technology platforms through user/peer groups, schools, seminars, and publications. Education: Bachelor’s degree in information technology or equivalent experience. Experience: Must have a minimum 5 years of experience in a database administrative and database development role, with specific experience using Microsoft SQL Server. Microsoft SQL Server certification is a plus. Experience in VMWare virtualization and centralized storage concepts and applications a plus. Certificates: N/A Special Requirements: Excellent verbal and written communication skills, Strong analytical skills, Able to make appropriate recommendations, Work well with in a team and independently. Good problem solving skills Regards, *Sharath,* *H**alcyon **S**olutions, **I**nc.* 5880 Innovation Drive,Dublin, Ohio 43016 www.halcyonit.com *Email: **skanukun...@halcyonit.com* <skanukun...@halcyonit.com> Gmail: sharathk.usstaff...@gmail.com *Celebrating 25 years in Business ! Halcyon is a CMMI Level 3 company.* The contents of this message and any attachments are intended solely for the addressee(s) named in this message. This communication is intended to be and to remain confidential and may be subject to privilege. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender and then destroy this message and its attachments. Do not deliver, distribute or copy this message and/or any attachments and if you are not the intended recipient, do not disclose the contents or take any action in reliance upon the information contained in this communication or any attachments. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
