*Please revert with resume @ [email protected] <[email protected]>*
Face to face will be required Try one local TMG Scranton, PA *SQL DBA* *6 month contract to hire* * Position is located on site in Scranton / Jessup, PA ******** Candidates must not require sponsorship to work in the US ********* *The Senior Database Administrator will join the existing DBA Team who are responsible for the support of a number of databases, principally on MSSQL platforms, on Windows Servers, in addition, a small number of MySQL and PostgreSQL databases. The post-holder will become involved in databases throughout their lifecycle from project inception to ongoing support.* The post holder will also act as deputy to the Team Leader and will have some team leading responsibilities on an adhoc basis. *Responsibilities:* • To represent Operations in meetings to cover operational requirements both for new projects and to feedback issues to development teams about current systems • To maintain production environments relating to the online services. • Maintaining high availability databases in support of 24*7 services • Establishing and monitoring backup schedules • Tuning database configuration for optimum performance • Installing/Patching MySQL, PostgreSQL, MSSQL software to agreed standards • Diagnose and resolve problems relating to database service availability • Monitoring and maintaining quality assurance by checking the consistency, continuity and coherence of supported services • Assisting development teams with effective schema design to achieve optimum performance • To work in a team environment and to work closely with other members of the team and customers • To keep abreast of technical developments of operational importance and to participate in developing or setting standards as directed • Develop and administer strategies for the control and sharing of company database resources and services. • Ensure the stability and reliability of data access and data quality across the organization via ongoing database support and maintenance. • Analyze user requirements for reports, forms, queries, and data extraction. • Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes. • Provide end-user training as necessary with regards to the effective and efficient use of database tools and resources. • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. • Create and document models for new database development and/or changes to existing ones through data flowcharting. • Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. • Assist with the installation and configuration of relevant network components to ensure database access, consistency, and integrity. • Develop long-term goals for production databases in conjunction with data owners and department managers. • Respond to and resolve database access and performance issues. • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. • Advise on the allocation of physical data storage for database systems. • Develop, implement, and maintain change control and testing processes for modifications to databases. • Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. • Perform database transaction and security audits. • All other duties assigned. *Essential Skills* • Advanced understanding of MS SQL 2008/2012 gained through running critical systems • Management of multiple schemas through system development, test and live environments • Experience with MS SQL replication/Mirroring/CDC • Experience with SQL Sentry monitoring • Experience with Idera SQLSafe • Experience with MySQL Master-Slave / Master-Master replication • Good working knowledge of, and confidence administering on Windows platforms • Experience of Unix Scripting • Methodical and accurate while delivering to daily deadlines • Systematic approach to identifying faults and pursuing paths to resolution • Experience of specifying and installing new solutions *Desirable Technical Skills * • Experience with management of Microsoft SQL server • Experience with management of Informatica • Experience with management of PostgreSQL • Experience of project management processes • Experience of other monitoring packages such as Idera products and SQL Sentry Ability to foresee relevant issues and assist in proposing possible solutions • Experience of Team Leadership *Required Experience:* Position Requirements • College diploma or university degree in the field of computer science or related field and/or 6-8 years database administration work experience. • Expert understanding of database structures, theories, principles, and practices. • Excellent understanding of, and experience with, server-client computing and relational database environments. • In-depth experience with data management and data processing flowcharting techniques. • Expert knowledge of reporting and query tools and practices. • Strong working technical experience with designing, building, installing, configuring and supporting database servers, including MS SQL Server • Hands-on database tuning and troubleshooting experience. • Good understanding of the organization’s goals and objectives. • Knowledge of applicable data privacy practices and laws. • Good interpersonal, written, and oral communication skills. • Strong technical documentation skills. • Ability to conduct research into database issues, standards, and products. • Ability to present ideas in user-friendly language. • Highly self motivated and directed, with keen attention to detail. • Proven analytical and problem-solving abilities. • Able prioritize and execute tasks in a high-pressure environment. • Strong customer service orientation. • Experience working in a team-oriented, collaborative environment. *Additional Comments:* Work Conditions • After hours on call support required • Sitting for extended periods of time. • Dexterity of hands and fingers to operate a computer keyboard, mouse, and to handle other computer components. • Lifting and transporting of moderately heavy objects, such as computers and peripherals. Thanks & Regards, *Viren Yadav* *Source Infotech Inc.* 40 Brunswick Avenue, Suite # 200, Edison, NJ, 08817 EMAIL: *[email protected]* <[email protected]> Gmail: *[email protected] <[email protected]>* *Phone:* *732-722-2842* | Fax: *732-909-2282* | Gtalk/Yahoo: *viren.rgtalent* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
