*Hi,* * *
*Position: Sr. SQL Server Database Administrator* Location: Boston, MA Duration: 9 Months + *Interview: Face to Face interview may be required after successful phone interview* * * *SUMMARY OF JOB**:* · *Min 8 years’ experience with T-SQL and SQL Server Management Studio within a SQL Server environment, ranging from SQL Server 2000, 2005, 2008 & 2012.* · *5 years’ experience in SSIS and SSRS*** · Provides SQL Server Database Administration and Application Development activities with duties including: o performance tuning, operating platforms, data modeling, design, development, monitoring, database capacity and utilization, server applications security, archiving, backups, disaster recovery, and documentation based on policies, industry best practices, and customer based business requirements; o construct and maintain data systems to ensure efficient data access and usage, security (permission and access) and protection of the data; o working on the physical data models and architecture with the team; o collaborating with the data stewards to ensure policies, definitions, and rules reflect attributes; o perform data integrity and quality audits, developing Database Administration policies and procedures as needed. * * *RESPONSIBILITIES:* Include, but not limited to, the following: * * *Server Planning*** · Plan, allocate, install, and configure SQL Servers (with appropriate patch level) · Plan and implement development, staging, and production database environments · Plan, implement, and maintain Backup and Disaster Recovery solutions * * *Database Administration*** · Plan, create, implement, monitor, and maintain backups; restore databases as requested · Plan, create, implement, and maintain database maintenance plans, including DBCC, defragging indices, etc.; including all supporting documentation. · Plan, monitor, request allocation and maintain appropriate amounts of disk storage for all SQL Servers; communicate storage estimates to Network Solutions group · Ensure optimal database and/or server performance, availability, and capacity utilization through proper server configuration, hardware recommendations, software utilities (e.g. defrag utility), individual issue resolution, etc. · Maintain proper patch levels on SQL Servers · Provide technical support, troubleshooting and resolution for database related issues · Create new databases as requested · Review query plans, optimize index usage, perform TSQL code review and optimization as needed * * *SQL Server Security Administration*** · Maintaining proper server, database and data access controls · Perform internal security audits and scans, identify vulnerabilities · Plan and recommend SQL Server security strategy · Organize and facilitate external audits *Architecture*** · Develop comprehensive understanding of current database systems · Participate in strategic planning of database technology usage such as SQL Server version levels, hardware levels, job automation, failure notifications, server monitoring, etc. *Additional Responsibilities*** · Managing and maintaining the current database deployment process · Managing and maintaining user set up / access · Scripting and troubleshooting database code fixes · Troubleshooting performance issues · Perform some Data Analysis * * *QUALIFICATIONS:*** · The candidate must have strong analytical, detailed, problem solving, troubleshooting, and organizational skills · Solid oral and written communications skills with technical and non-technical individuals in a positive and professional manner in a highly dynamic environment. · Familiarity with all phases of the software development life cycle while working within a software development organization. · Ability to work independently with limited supervision and guidance. · A Bachelor’s degree or equivalent combination of experience and education is required. · Minimum of eight years’ experience with T-SQL and SQL Server Management Studio within a SQL Server environment, ranging from SQL Server 2000, 2005, 2008 & 2012. · Minimum of five years’ experience in SSIS and SSRS development and administration. · Experience with configuration management tools, i.e. Visual SourceSafe, Team Foundation. · Minimum 2 years’ experience with a scripting or .Net language for managing SQL command files and C# programs used in an automated database build environment. *Thanks & Best Regards,* * * *V**INNI **| Oberon IT*** 1300 W. Walnut Hill Lane, Suite: 263, Irving, TX 75038 *Email *-*[email protected] |**Direct: *972-330-4350; *Fax: *1-800-218-2820 *www.oberonit.com* -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send an email to [email protected]. Visit this group at http://groups.google.com/group/hrccpl. For more options, visit https://groups.google.com/groups/opt_out.
