This listing was posted on ApplicantList.
Advisor Programmer Analyst - SQL
Location:
Atlanta, GA
Description:
Job Title: Advisor Programmer Analyst - SQL Performance Tuning Expert/DeveloperLocation: RemoteMax Rate: $98/hourWe are seeking a SQL Performance Tuning Expert/SQL Developer to provide core technical expertise in supporting and managing Microsoft SQL Server in a highly challenging environment. This position requires an individual who is an expert in writing complex queries and has experience in SQL Performance Tuning. Please note, we are not looking for a standard SQL Server DBA, but a DBA/SQL Developer that has application performance experience. This is a must-have.Responsibilities: 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 recommendations 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 Responsible for 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 the 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. Requirements: Bachelor's Degree or equivalent experience. A minimum of 10 years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated. Experience with a health insurance company, TPA, or claim processor and a thorough understanding of the underlying structure of claims transactions Experience with Healthcare EDI standards such as 835s. Experience with job scheduling tools. 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. Knowledge of SSIS and SSRS. Job Posted by ApplicantPro
Company:
Fortuna BMC
Posted:
January 25 on ApplicantList
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to ApplicantList
Important Safety Tips
- Always meet the employer in person.
- Avoid sharing sensitive personal and financial information.
- Avoid employment offers that require a deposit or investment.
To learn more, visit the Safety Center or click here to report this listing.
More About this Listing: Advisor Programmer Analyst - SQL
Advisor Programmer Analyst - SQL is a Computer & Software Jobs Programmer Analyst Job at Fortuna BMC located in Atlanta GA. Find other listings like Advisor Programmer Analyst - SQL by searching Oodle for Computer & Software Jobs Programmer Analyst Jobs.
Advisor Programmer Analyst - SQL is a Computer & Software Jobs Programmer Analyst Job at Fortuna BMC located in Atlanta GA. Find other listings like Advisor Programmer Analyst - SQL by searching Oodle for Computer & Software Jobs Programmer Analyst Jobs.