Sr. DATABASE ADMINISTRATOR/ SQL DBA - AZURE, REMOTE

Company: CGS Business Solutions - INC 5000 Company
Location: New York
Posted on: May 16, 2022

Job Description:

CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:
Our Large Financial client in Orange Co, CA is looking for a Remote Sr. Database Administrator/ SQL DBA to join a highly skilled team of professionals for a 1 year+ contract. This is a Senior position to be performed under minimal supervision and direction. The Sr. Database Administrator is responsible for deployment, migration, implementation, and administration of databases including control, maintenance, and support of all database environments and related applications. Environment is both on premise, and in the Cloud using Platform As A Service (PaaS) and Infrastructure As A Service (IaaS)
SKILLS/ EXPERIENCE REQUIRED:

• Minimum 5+ years in a MS SQL Server Database Administration role within large Enterprise Databases (100MB to 5TB)
• Extensive experience with Microsoft SQL 2000- 2016 database principles (SQL 2019 experience a plus) and utilities including database restores, performance tuning, backups, query optimization, diagnosis of latency and indexing issues and maintaining the overall general database health.
• Experience troubleshooting the integration with SQL ensuring queries are returned efficiently, SQL Reports (PBIRS) and front-end database interfaces and web API's are optimized.
• Familiarity with Monitoring tools such as SolarWinds, Redgate or Idera
• Previous experience with working with Datawarehouse teams
• Knowledge of Azure Data Lake/Data Factory
• Cross functional Database experience a plus (Oracle)
• Familiarity with NPPI data encryption knowledge a plus
• Willing to work after hours and adhering to an on-call rotation schedule (2 weeks on/ off)
• Comfortable with moving to a 4/10 schedule after probation period
• BA or BS in Computer Science or equivalent years of experience RESPONSIBILITIES:
  • Implement and administer MS SQL Server 2008-2019 databases in support of in-house developed and vendor applications for both on premise and Cloud PaaS environments
  • Develop, implement and execute maintenance plans to maximize availability, performance, and reliability of databases.
  • Develop and implement measures of availability, performance, and reliability of databases.
  • Assist with SSIS Package/Project Deployment and Configuration
  • Assist with migrating SSIS Packages/jobs to Azure SSIS Integration Runtime
  • Assist with migrating to SSRS/PBIRS
  • Working knowledge of Database Partitioning (Create, Merge etc.), FileGroups
  • Review, plan, test, and implement database upgrades while adhering to all change management policies and procedures.
  • Configuration, installation, and setup of database servers as required.
  • Documents business applications architecture and process flow using MS Visio or other modeling tool.
  • Develop, implement and execute a backup / disaster recovery plan for all databases via various technologies (log shipping, database mirroring, SAN replication, etc.).
  • Review and perform strategic database planning; test and implement database upgrades while adhering to all change management policies and procedures.
  • Coordinate configuration, installation, and setup of application and database servers as required
  • Troubleshoot and resolves problems with production systems; escalates issues and facilitates resolution.
  • Work with program owners in the review, planning, testing, and implementation of program upgrades dependent on database technology.
  • Make recommendations to system analysts and other staff on administration policies and procedures and technical methods.
  • Troubleshoot and resolve database connectivity and performance problems.
  • Present relevant application and database performance statistics including server performance and trend analysis.
  • Perform in-depth analysis of application security, performance and health at system and network level; makes relevant recommendations to improve system availability and reliability based on this analysis and coordinates the implementation of approved changes.
  • Represent Server engineering team at meetings with other teams and business partners.
  • Guide development of technical documentation for production applications.
  • Document business applications architecture and process flow using MS Visio or other modeling tool.
  • Identify requirements and makes technical recommendations based on industry best-practices according to identified requirements. IMPORTANT SOFT SKILLS REQUIRED:
    • Technical - Generate creative solutions and apply design principles. Strive to continuously build on knowledge and skills by pursuing training and development. Always look for ways to improve and promote quality. Design good workflows and procedures.
    • Problem Solving/ Strategic thinking/ Planning & Organizing skills - Identify and resolves issues and develop alternative solutions. Ability to make decisions, exhibit sound and accurate judgment with supportive reasoning for decisions. Strong use of prioritization skills and planning work activities; develop realistic action plans and uses time efficiently. Demonstrate attention to detail.
    • Teamwork - Be a strong team player by sharing expertise with others. Exhibit objectivity and openness to others' views; Contribute to building a positive team spirit putting success of team above own interests; help build and maintain morale and group commitments to goals and objectives About CGS Business Solutions:CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.

Keywords: CGS Business Solutions - INC 5000 Company, New York , Sr. DATABASE ADMINISTRATOR/ SQL DBA - AZURE, REMOTE, IT / Software / Systems , New York, New York