Sr Pro Programmer Analyst SQL

BCforward is currently seeking a highly motivated Sr Pro Programmer Analyst SQL for an opportunity in Remote

Position Title: Sr Pro Programmer Analyst SQL

Location: Remote
Anticipated Start Date: 06/10/2024.

Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.

Expected Duration: 24+ Months Contract with Strong Possibility of Extension.

Job Type: [Contract (40 hours weekly)], [Remote]
Pay Range: $53/hr - $55/hr

Please note that actual compensation may vary within this range due to factors such as location, experience, and job responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem, etc.).
Job Description:
Your role in our mission:

• Provide core technical expertise to support and manage Microsoft SQL Server in a highly challenging environment.
• Provide expertise in writing complex queries.
• Perform SQL performance tuning.
• Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects using SQL/T-SQL
• Analyze database and system response time and determine optimization and tuning recommendation to improve query performance.
• Review long running SQL's in production database and recommend for tuning.
• Work with application/development teams to assist in overall database design, helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures.
• Analyze Microsoft SQL Server tables data volume and provide recommendation for indexes and triggers.
• Maximize database stability, up time of databases including Production, Test, Development environments through system monitoring, performance tuning, and routine maintenance tasks such as index rebuilds, file compression, statistical updates, and database consistency checks.
• Manage the storage environments for the databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.
• Create and assign database roles and privileges.
• Create and execute database backup and recovery policies and maintain integrity and reliability of access to information.
• Import and export data to and from the database servers.
• Perform routine backup and recovery testing, including testing and documenting recovery scenarios.
• Conduct database performance monitoring and capacity planning.
• Monitor and analyze disk I/O, queue lengths.
• Conduct troubleshooting of issues associated with supported SQL databases.
• Perform SQL performance tuning tasks.
• Create and maintain detailed SOPs, configuration documentation, and maintenance plans for the database environment.
• Assist internal client teams with management of production server systems such as network security teams, cloud teams, system security officers.
• Serve as technical liaison between IT teams.
• Provide support of client site change control activities, supporting change control requests and review boards with respect to system implementation.
• Perform security hardening via group policies, local policies, scripting, etc.
• Distinguish between necessary security settings that would protect the system while ensuring usability versus security settings to meet security compliance.
• Understand and translate business needs into data models supporting long-term solutions.
• Work with the application development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Evaluate data models and physical databases for variances and discrepancies.

What we're looking for (top 5 only):

• 10+ years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated.
• Extensive expertise in Microsoft SQL Server database, as well as data modeling, both logical and physical.
• SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure.
• Extensive knowledge in Data De-identification and Test data preparation.
• Extensive experience with collecting business requirements from customers and transform the requirements into DB data processes and data schema.
• What you should expect in this role
• This position is remote.
• This position is part of a rotating on-call team.

Recommended Additional Skills/Experience:

• Minimum of bachelor's degree or equivalent experience.
• Experience with Healthcare EDI standards such as 835s.
• Knowledge of SSIS and SSRS
• Experience with job scheduling tools.
• Experience with a health insurance company, TPA, or claim processor and a thorough understanding on the underlying structure of claims transactions.
• Role is not a standard SQL Server DBA, but rather a DBA/SQL Developer that has application performance experience. This is a must have.

Benefits:

BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

Keywords: Data Engineer, ETL, SQL, Teradata, Ab Initio, Azure, Unix, Linux

About BCforward:

Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.

BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best in class place to work.

BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.

To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.

This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 223114 when responding to this ad.