*CANDIDATES MUST BE LOCAL TO AUSTIN, TX.*
Good Afternoon, I hope you're doing well! I am working with a client who is looking for a SQL Server DBA, this is a 6+ month contract located in Round Rock, TX with opportunity for extension. The candidate MUST be onsite Monday-Friday, this is not a remote role. SQL Server DBA Database Administration Sr. Advisor to support Production, Non Production Database Servers & Projects for Internal IT Segment Role Responsibilities Admin skillset Database Administration for the SQL Server 2005 and above (Maintenance, Security, Upgrades, Performance Tuning, etc.) Installing, Configuring and Upgrading SQL Server/Applying Service Packs Server and Database Security Administration SQL Server Replication Designing SQL Server Systems and Implement A good knowledge of the physical database design Create database objects (tables, indexes, etc.) Write database procedures, functions and triggers Tune database queries, tuning and Monitoring SQL Server Code or data synchronization Ensure data consistency in the database through DBCC commands. Should have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries Should be very strong in replication concepts and troubleshooting replication issues with in SLA Extensive experience in designing and handling Disaster recovery/high availability Failover Clustering and Data Modeling Implementation experience in Enterprise wide automation tools/custom automation. Data Transformation and Loading Experience with SSIS and SSRS troubleshooting Upgrade from DTS to SSIS packages Backup the current code for rollback purposes Analysis - Analyze the data to determine the core problems Testing - Test the various options to ensure they perform better and do not cause worse performance in other portions of the application Plan growth and changes (capacity planning) Perform general technical trouble shooting and give consultation to development teams Interface with Microsoft Corporation for technical support. Patch Management and Version Control Tools Should have good understanding of the MS SQL, related utilities and tools Identification - Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools Backing Up and Restoring SQL Server, Knowledge of ALL MS DB backup and recovery scenarios Establish and maintain sound backup and recovery policies and procedures Backup tools, Performance tools, Check for failed processes Research errors, Validate disk space is not low, validate none of the databases are offline or corrupt Perform database maintenance : Perform both MS SQL and operating system performance tuning and monitoring Automation: Monitor application related jobs and data replication activities (Automated) Setup custom scripts to query for particular issues and email the team Write error messages centrally in the application and review that data Setup Operators and Alerts on SQL Server Agent Jobs for automated job notification SoftSkill Should have sound communication skills with management, development teams, vendors and systems administrators Setup and maintain documentation and standards Review the current process to understand what is occurring Determine what the business and technical problems are with the process Document the requirements for the new process Provide a strategic database direction for the organization Should have the ability to handle multiple projects and deadlines Should possess a sound understanding of the business Good understanding of the underlying operating system Level of experience At least 8-10 or more years working as a DBA and handling production critical databases/Servers. 7 or more years of experience as a SQL Database Administrator/Engineer 7 or more years of hands on Production/Development DBA/DBA experience. Education Masters or Bachelor's degree in any discipline Thanks & Regards, *Fazal* *Aspire Systems Inc*. / *Ph # (732) 414 2854* *Certified Minority Owned Business Enterprise (MBE) from NMSDC* *NYS MBE Certified ( New York State MBE Certified)* *E-Verified Approved Employer* *Four Time Award Winner ( 2009* & 2010 & 2011 & 2012) Best of Danbury Award Approved Inc. 500 Company *Corp Office: **36 Mill Plain Road, Danbury, CT 06811* *Fax : 203 798 0060* *Email: [email protected] <[email protected]>* *Gtalk: fazalmrecruiter* *URL: **www.aspiresystem.com* <http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://www.aspiresystem.com> -- You received this message because you are subscribed to the Google Groups "java-core" 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/java-core. For more options, visit https://groups.google.com/d/optout.
