Greene Resources

Give us a call: 800-784-9619

Job Profile

Lead DBA MS SQL Server

Job Number: 18812

Job Description

Our client in Raleigh needs immediate help with creating and deploying physical MS SQL Server databases through the entire build process. Design and implement back-up, recovery, archiving, conversion strategies, and performance tuning. Define and develop database standards, policies and procedures and provide solutions utilizing new database features and functionality for optimization

Job Responsibilities

  • Manage and lead the design and distribution, performance, disaster recovery strategy (replication database mirroring, log shipping), windows and database security, availability and access requirements for large complex databases
  • Design and develop physical layers of various databases making use of advanced features such as partitioning, creation of database, table, index planning, triggers and Store Procedure, SSIS packages, views, schemas capacity planning and monitoring and database maintenance
  • Consult and advise application development teams on database design, Database and Windows, query optimization and performance, query tuning, troubleshoot & resolution, physical modeling, Disaster Recovery strategies
  • Optimize physical model to ensure efficient and reliable database performance and performance tuning by analyzing database and OS performance and implementing tuning and optimization recommendations; database monitoring, windows and SQL server clustering
  • Provide technical lead assistance and mentoring to staff in all aspects of database management and trouble shooting

Education Requirements

  • Bachelor's in Computer Science or related, or 10 years relevant work experience

Other Requirements

  • 8+ years IT experience: MS SQL Server, Windows and scripting
  • Intermediate to advanced Microsoft Office skills: Word, Excel, Power Point and Access

Additional Information

  • Strong scripting skills relevant to DBA
  • Experience in insurance, financial services or management consulting