Fulltime SQL openings in Chicago, United States on September 05, 2022

SQL Solutions Business Analyst at Spencer Stuart

Location: Chicago

SSI (U.S.) Inc. d/b/a Spencer Stuart

Spencer Stuart is an equal opportunity and affirmative action employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.

Location: Corporate/Chicago

Full/Part Time: Full time

Req ID: R1895

Position Summary

The SQL Solutions Business Analyst will design scripts and programs to perform specific database functions and to analyze and maintain finance data and business processes. This role is part of a key support function for the Workday ERP and integrated systems that are the foundation of operations for a global firm.

Core tasks associated with this job include the following:
• Integrate data from multiple data sets into one database system to streamline information
• Program specific database functions to create database triggers and design data tables
• Design reports to show statistics and other information about specific database topics
• Remove dead data files and other irrelevant information to free up database space
• Write scripts to analyze data and perform specific data queries
• Isolate and resolve issues with data and databases
• Collect data from multiple sources and add it to the database
• Provide ERP/CRM Post-Production support and maintenance activities as needed

Key Relationships

Reports to:
• Finance Solutions Architect

Other Key Relationships:
• Enterprise Solutions
• Operational Excellence
• Chicago Development
• Chief Information Officer
• Change Management Team
• Global Practice and Function Leaders
• Consultants, Associates, Research Analysts and EAs
• Chief Financial Officer and key finance stakeholders

Candidate Specification: Key Selection Criteria

Ideal Experience
• Bachelor’s degree in Information Systems or related discipline required
• 1-3 years of experience or equivalent knowledge in mastering database management software/tools, including proficiency in SQL query building and report writing
• Must be resourceful, industrious, and willing to take on new tasks and proactively learn new technologies to keep up with business needs
• Must be able to work under tight deadlines efficiently and with high quality
• Must possess strong organizational skills with demonstrated attention to detail
• Must be flexible and able to adapt in a changing business environment
• Must possess a positive attitude and strong work ethic
• Exposure to Workday or similar ERP system preferred
• System Administration/Production-Support experience preferred
• Understanding of business needs, particularly from a Finance perspective
• Knowledge of business process configuration, security administration and reporting
• Experience managing system updates and releases

Special Skills/Must Be Proficient In The Following Or Willing To Improve Proficiency In These Areas:
• Structured Query Language (SQL)
• Cursory knowledge of programming and scripting languages (.Net C#, C++, VBS, etc.)
• Microsoft Office 2007/2010 (Excel, Access, Word, PowerPoint)
• Database structure and design
• Excellent written and oral communication skills

Location
• Corporate Office in Chicago, IL (with flexibility to work remotely)

Spencer Stuart is a proud equal opportunity and affirmative action employer. We are committed to non-discrimination without regard to actual or perceived race, ethnicity, creed, color, religion, gender (including pregnancy, childbirth or related medical conditions), national origin, immigration status, ancestry, age, marital status, protected veteran status, physical or mental disability, medical condition, genetic information, sexual orientation, gender identity, or any basis prohibited under applicable federal, state or local law.

All Spencer Stuart employees in the US must be vaccinated against COVID-19. We will provide reasonable accommodations for medical, disability or religious reasons or other legally required exemptions.

Please see job description

PI189586165
Apply Here
For Remote SQL Solutions Business Analyst roles, visit Remote SQL Solutions Business Analyst Roles

********

Sr. SQL Developer at Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas

Location: Chicago

Description

Job Purpose:

This position is responsible for assisting existing Database Administrator Leads and becoming a Lead in the Database Administrator (DBA) space. The DBA is responsible for design and develop physical database to meet project development requirements, including functionality, optimal performance, scalability and availability. Performance validation and tuning of new and existing databases. Troubleshooting of database issues and application issues that manifest when accessing the database.

Required Job Qualifications
• Bachelor Degree and 5 years Information Technology experience OR Technical Certification and/or College Courses and 7 year Information Technology experience OR 9 years Information Technology experience.
• Familiarity with Database Queries
• Knowledge with Database Design and Theories
• Ability to work with Data Architects and other IT Specialist to Set Up, Maintain and Monitor Data Networks
• Database Structure Language SQL or SQL/PSM
• SQL Server Developer
• SQL Server T-SQL including table design/creation, Stored Procedures, Triggers etc.
• SQL Server Integration Services (SSIS) packages – developing new, modifying existing ones and Debugging SSIS package issues. Both package and project deployment model
• Performance Tuning
• Problem solving skills including debugging issues related to database.
• SQL Server Upgrade experience
• SQL Authentication and/or Windows Authentication including Active Directory
• SQL Server Directory set up including recommending drive sizes etc
• Database Management Best Practices
• IT Security Best Practices
• SDLC Methodology (Agile / Scrum / Iterative Development).
• System performance management
• Business requirements management
• Problem solving /analytical thinking.
• Creative thinking

Preferred Job Qualifications
• Bachelor Degree in Computer Science or Information Technology.
Apply Here
For Remote Sr. SQL Developer roles, visit Remote Sr. SQL Developer Roles

********

sql dba at Insight Global

Location: Chicago

Must haves:

5-8+ years of experience as a DBA in administering, and managing relational databases like SQLServer

Ability to multi-task while maintaining high quality of deliverables

Demonstrable passion for learning new technologies.

Strong written and oral communication skills

A team player

Plusses:
• AWS, Azure and GCP experience
Day to Day:

This person will be responsible for implementation, configuration, maintenance, and performance of critical SQL Server systems in an enterprise environment.
Must be able to install, configure, troubleshoot, maintain, and upgrade relational databases.

Must be able to perform optimization and performance testing, provide technical support for incident response and reporting and provide on-call support as needed.
Job Duties:
Install, configure, and maintain SQL Server and processes

Monitor system’s health and performance

Install upgrades

Manage database backups and recovery

Manage storage for all applications

Manage security and report incidents

Create custom monitoring and maintenance plans

Refine and automate regular database tasks, track issues, and document changes

Provide suggestions for solutions

Assist developers with query tuning and schema refinement

Troubleshoot and resolve database problems

Ensure audit trails are maintained and documented

Test backup/recovery, failover, and disaster recovery

Provide 24×7 support for critical production systems

Minimum Requirements

Must haves:

5-8+ years of experience as a DBA in administering, and managing relational databases like SQLServer

Ability to multi-task while maintaining high quality of deliverables

Demonstrable passion for learning new technologies.

Strong written and oral communication skills

A team player

Plusses:
• AWS, Azure and GCP experience
Day to Day:

This person will be responsible for implementation, configuration, maintenance, and performance of critical SQL Server systems in an enterprise environment.
Must be able to install, configure, troubleshoot, maintain, and upgrade relational databases.

Must be able to perform optimization and performance testing, provide technical support for incident response and reporting and provide on-call support as needed.
Job Duties:
Install, configure, and maintain SQL Server and processes

Monitor system’s health and performance

Install upgrades

Manage database backups and recovery

Manage storage for all applications

Manage security and report incidents

Create custom monitoring and maintenance plans

Refine and automate regular database tasks, track issues, and document changes

Provide suggestions for solutions

Assist developers with query tuning and schema refinement

Troubleshoot and resolve database problems

Ensure audit trails are maintained and documented

Test backup/recovery, failover, and disaster recovery

Provide 24×7 support for critical production systems
Apply Here
For Remote sql dba roles, visit Remote sql dba Roles

********

Lead, MS SQL DB Admin at Northern Trust

Location: Chicago

MS SQL DBA Position Description GENERAL DESCRIPTION : This is an exciting opportunity for an experienced Microsoft SQL server Database Administrator who can immediately begin to add value to the Northern Trust Database Engineering division. The successful candidate will be part of a high touch team of DBAs engaged in supporting new Project development, Engineering efforts and Production Health/Stability at Northern Trust. The DBA will be responsible for sharing the support of the existing database infrastructure, working on problem resolution, root cause analysis (RCA) , deep dive troubleshooting. The DBA will be required to fully understand the inner workings of the Northern Trust Database Environment they support. You will be working with database administrators, application owners, business partners and other Infrastructure divisions to deliver the best possible product and solution for Northern Trust. Proactive engagement with Engineering and Managed Services teams will be needed to address issues in the infrastructure and avoid potential outages. Responsibilities and Required Skills
• Strong experience with the management of Microsoft SQL server;
• Senior level technical skills in MS SQL Server 2008 R2, 2012, 2014, 2016, and 2019 including system installation and upgrade, backup and recovery, data server migration, release management, troubleshooting, performance tuning, working with developers and third party vended products. Expertise in SSIS jobs, SQL server Agent Job, Control M jobs and maintenance plans
• Experience with management of Microsoft SQL server failover clustering, Always On, Availability Groups, replication and database mirroring features.
• Familiar with Installing and supporting particular features such as Integration Services, Reporting Services and Analysis Services.
• Experience and managing 3rd party vendor applications. Good working knowledge of, and confidence administering on Windows.
• Scripting skills required for automation of database jobs e.g. Monitoring, Alerting, stats gathering
• Experience working within a project management processes;
• Methodical and accurate while delivering tasks, working within project deadlines.
• Systematic approach to identifying issues and pursuing paths to resolution;
• Experience installing and building new solutions or improving existing applications;
• Ability to foresee relevant issues and assist in proposing possible solutions, Performance and Tuning expertise a must, root cause analysis in a Firecall situation;
• Experience with MS SQL Enterprise Monitoring tools;
• Management of multiple schemas/databases through system development, User Acceptance testing and production environment;
• Fixing or enhancing infrastructure scripts (backups, expanded monitoring and alerting,etc)
• Space and Capacity Validation.
• Fixing systemic problems that arise from an incident.
• Updating build scripts that have new requirements (new user account, new permissions, different configuration, new versions etc.)
• Building out and scheduling maintenance jobs
• Deploying scripts across the environment
• Decommissioning old databases that are no longer in use
• Proactively validating the environment (services missing, inconsistent configurations, periodic checks and fixes) and addressing the problems
• Focus on Production stability and resiliency.
COMPETENCIES
• Ability to cope in a technically complex and fast-changing environment, and to respond calmly and rationally to changing priorities in a deadline-driven situation.
• Strong planning and organizing skills including the ability to manage several work streams simultaneously.
• Ability to think strategically and evaluate options in the short, including capacity planning at medium and long term.
• Good communication skills with a capacity to present, discuss and explain issues coherently and logically both in writing and verbally.
• Clear decision-making ability with the facility to judge complex situations and assess when to escalate issues.
• Ability to balance conflicting and changing demands through prioritization and a pragmatic approach.
• Demonstrated leadership ability to plan and delegate work.
• Good team player, self-motivated and able to work on own initiative.
Qualifications
• Minimum of 4 – 6 years of experience in administrating medium to large databases in complex enterprise environments
• Strong scripting and automation skills.
• Experience with SQL Server AlwaysOn on large database clusters
• Database experience from working on engineering or project implementations team
• BS in Computer Science or equivalent experience
• Experience migrating On-Prem environments to Azure a plus
• Cohesity backup knowledge a plus
• Experience in the Financial Industry a plus
• Exposure on other Database Management Platforms a plus
About Northern Trust: Northern Trust provides innovative financial services and guidance to corporations, institutions and affluent families and individuals globally. With over 130 years of financial experience and nearly 20,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service. Working with Us: As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company that is committed to strengthening the communities we serve We recognize the value of inclusion and diversity in culture, in thought, and in experience, which is why we are honored to receive the following awards in 2021:
• Gender Equality Index Member , Bloomberg
• Top Financial & Banking Company , Black EOE Journal, Hispanic Network Magazine, Professional WOMAN’S Magazine
We’d love to learn more about how your interests and experience could be a fit with one of America’s best banks and most sustainable companies Build your career with us and apply today.
Apply Here
For Remote Lead, MS SQL DB Admin roles, visit Remote Lead, MS SQL DB Admin Roles

********

Senior SQL Database Engineer at CSC Corptax

Location: Chicago

Job Description
The safety and security of CSC Corptax’s current and prospective employees, customers, and the communities we serve are our top priorities.
Due to coronavirus (COVID-19) concerns, we have transitioned to virtual interviews for the foreseeable future. We look forward to all upcoming video and phone interview conversations with our prospective candidates.
We’re always in search of top talent to join the CSC Corptax family. If you’re looking for a career change, don’t hesitate to apply or reach out to us. We’ll have virtual interactions until we’re able to move forward with in-person interactions.
Do you value rewarding software development projects, working with the latest Microsoft® tools, access to training and career advancement, and working with great people in a positive culture?
We do too
Software engineering at CSC Corptax is core to how we serve our customers and is one of our differentiators in the marketplace. Our innovative, reliable, and award-winning tax automation solutions are built on a culture that emphasizes teamwork, agility, and the ability to think beyond the obvious by leveraging the experience and tenacity of our people.
At CSC Corptax, successful Database Engineering Team members should have a strong working knowledge of the latest Microsoft tools and technologies used to develop .NET web applications. You’ll play an active role in the design and development of features for our cloud-based commercial tax software. You’ll also help identify and leverage exciting new technologies, define best practices, and guide the optimization of a large and growing technology portfolio. Any company can build an application, but we’re striving to deliver an innovative end-to-end tax platform that enables business agility.
We are seeking highly motivated and passionate Senior Database Developer to join the team here at Corptax. In this role you will help design, develop and maintain the database side of our commercial software product. We are a Microsoft environment and feature the many of the latest development tools including SQL 2019, Visual Studio 2019, Azure DevOps, Azure, Cloud Services, TypeScript, Angular 4, C#, and more.
Responsibilities:
• Design, develop and maintain the database side of our commercial software product
• Identify areas for database schema and code improvement
• Troubleshoot and resolve performance and resource usage issues
• Research, prototype and apply latest database technologies

Qualifications:
• BS or MS in Computer Science or related field
• A candidate for this position must have had at least 5 years of working experience working in a data engineering or database development, preferably as a Data Engineer in a fast-paced environment.
• Strong working knowledge of Microsoft SQL Server 2019 and its eco system
• The candidate must have strong working knowledge in database design and modeling.
• The candidate must be proficient in T-SQL programming and performance tuning.
• The candidate must demonstrate proficiency in any one of the scripting languages, for example, PowerShell, Python
• The candidate for this position must possess an ability to perform complex data analyses with large data volumes.
• Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects including building reports and data visualizations
• Experience with Microsoft Azure, Power BI, machine learning is a plus
• Demonstrated ability to work independently and be a self-starter.

What can we offer you?
• Competitive compensation and benefit programs including 401(k), medical, dental, vision, and vacation plans are just a few of the many available perks
• Continuous on-the-job training, mentoring, Visual Studio and Pluralsight subscriptions, and the opportunity to learn from experienced and talented software professionals
• Opportunity to work with customers directly and have an immediate and direct impact on their work
• Sit or stand work stations, dual monitors available, SSD hard drives, i7 CPU, 64gb machines
• A casual work environment with flexible schedules and work-from-home options
• Our diversity is our strength. Our employees create an environment where everyone is valued and respected. Diverse teams give us a competitive advantage and drive innovation. We’re empowered to do what is right for each other and our customers. Though we have many diverse employees, we’re one company that encourages everyone to bring their best selves to work every day. We’re better together. Some people call this diversity and inclusion-we call it being genuine. CSC Corptax is an Equal Opportunity Employer

#corptax #remote #LI-Remote #BI-Remote
About Us
CSC is the world’s leading provider of business, legal, tax, and digital brand services to companies around the globe. From keeping your business in compliance and streamlining operations, to protecting and promoting your brand online, we use our expertise and personal approach to help your business run smoother. We are the business behind business. We are the trusted partner for 90% of the Fortune 500®, more than half of the Best Global Brands (Interbrand®), nearly 10,000 law firms, more than 3,000 financial organizations, and are a nationally recognized Top Workplace. Headquartered in Wilmington, Delaware, USA since 1899, we have offices throughout the United States, Canada, Europe, and the Asia-Pacific region. We are a global company capable of doing business wherever our clients are-and we accomplish that by employing experts in every business we serve.
Our diversity is our strength. Our employees create an environment where everyone is valued and respected. Diverse teams give us a competitive advantage and drive innovation. We are empowered to do what is right for each other and our customers. Though we have many diverse employees, we are one company that encourages everyone to bring their best selves to work every day. We’re better together. Some people call this diversity and inclusion-we call it being genuine. CSC is an equal opportunity employer.
Disclaimer: The information above describes the general nature and level of work performed by employees in this role. It is not intended to be a description of all duties, responsibilities, and qualifications.
About the Team
At CSC®, we’re always looking ahead, finding ways to improve and anticipate the future needs of our customers. Curiosity fuels our innovation and productivity drives our results. This proactive mindset has helped us adapt and create solutions that have enabled businesses to run smoother and smarter for more than 120 years.
CSC is committed to attracting, developing, and retaining talented people whose personal values align with ours. We empower our employees to bring the right solutions to market to meet customer demand. That is why we are the premier provider of global solutions for more than 180,000 businesses.
• CSC is a great place to work with smart and dedicated people. We have been voted a Top Workplace every year since 2006 and are a 2022 National Top Workplace.
• We offer challenging work and career opportunities. Most positions are filled with internal moves and employee referrals.
• Employees are eligible for an annual success sharing bonus or commission plans based on role and individual performance.
• CSC offers excellent benefits, including medical, dental, life insurance, and flexible spending and health savings accounts. We also offer you a 401(k) with employer match and profit-sharing, paid time off, tuition reimbursement, and more.
• Our global standard for our work environments supports current and future technology initiatives through open design, sit-stand workstations, and digital interface points with wireless access throughout the campus. It’s an exciting time for us in terms of growth and expansion.
Apply Here
For Remote Senior SQL Database Engineer roles, visit Remote Senior SQL Database Engineer Roles

********

SQL Developer (Mid-Tier)-GMOT at Bank of America Corporation

Location: Chicago

Job Description:

Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust, and well-tested interfaces. Familiar with the development and testing practices of the bank. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilize multiple architectural components (across data, application, business) in the design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Contributes to existing test suites (integration, regression, performance); Analyzes test reports, identifies any test issues/errors; Triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Participates contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, and release notes. Individual contributor.

Responsibilities
• Exciting opportunity to work as part of a global team with a focus on US billing technology.
• The successful candidate will be expected to liaise with both technical and business colleagues globally at locations in India, Dublin, New York, and Chicago.
• Working directly with application stakeholders and business partners to automate the billing processes and provide analytics for client billing processes.
• Delivering across our billing platforms utilizing TSQL, .Net, Angular, and Tableau technologies.
• Delivering solutions in a fast-paced agile environment working to deliver initiative projects to enhance our platforms.

Required Skills:
• Must have a minimum of 5 + years of experience with TSQL databases.
• Should have a minimum of 3 years of experience in agile delivery.
• Should have a minimum of 3 years of experience in ETL tools such as SQL server SSIS
• Should have a minimum of 2 years experience of in JIRA, Jenkins, and GIT.

Desired Skills:
• Financial Services experience in back-office operations is desirable.
• Nice to have experience with.Net/Angular.
• Nice to have. experience with BI tools such as tableau.

GMOT Bank of America:
• Beliefs diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world.
• Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully.
• Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals.
• Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience.
• Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs.
• Believes in responsible growth and is dedicated to supporting our communities by connecting them to lending, investing, and giving them what they need to remain vibrant and vital.

Shift:

1st shift (United States of America)Hours Per Week:

40

Full time

JR-22081994

Travel: No

Share:
Street Address
Primary Location:

Applicants with Disabilities

Bank of America is committed to ensuring that our online application process provides an equal employment opportunity to all job seekers, including individuals with disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to submit an application, please contact us by calling 1.877.760.2076. This is a dedicated line designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Only messages left for this purpose will be considered. A response to your request may take up to two business days.

Please note: Messages left for other purposes such as following up on an application or non-disability related technical issues, will not receive a response.
Apply Here
For Remote SQL Developer (Mid-Tier)-GMOT roles, visit Remote SQL Developer (Mid-Tier)-GMOT Roles

********

SQL Database and Systems Administrator at Myticas Consulting ULC

Location: Chicago

The team at Myticas Consultig is looking for an SQL Database and Systems Administrator to ensure stable operation and support their integration to critical Back Office Systems. We are looking for a Database System Administrator to also support Red Hat Linux and Windows Server with familiarity with Oracle database design, coding, and documentation with a strong knowledge of database backup procedures, recovery systems and SQL.

Essential Responsibilities:
• Installing/maintaining Linux, Windows and Oracle database software across all environments
• Setting up accounts and workstations
• Ensuring security through access controls, backups and firewalls
• Developing expertise to train staff on new technologies
• Building an internal wiki with technical documentation, manuals and IT policies
• Providing performance Tuning to maintain high-availability and efficient processing
• Performing on-site analysis, diagnosis of complex system problems and recommends and implements corrective solutions including off-site repair as needed
• Monitoring/Providing recommendations on management of disk space and gjobth
• Reviewing performance logs, event logs, and system logs
• Performing routine maintenance to systems as needed
• Troubleshooting problem areas in a timely fashion in person, by phone or via email
• Prioritizes documenting issues and resolutions in the JIRA Tracking Software
• Participating in Disaster Recovery Exercises

REQUIREMENTS:
• Proficiency with SQL, Red Hat Linux, UNIX, Oracle DB, MS SQL Server, and other Microsoft Products
• Proven Experience as a Data System Administrator supporting Red Hat Linux and Windows Server
• Familiarity with Oracle database’s design, coding and documentation.
• Experience with database backup procedures, recovery systems and SQL.
• Some Knowledge of programming languages and API’s.
• Knowledge of intrusion detection systems
• Ability to understand algorithmic structures.
• Linux/Unix certification is a plus
• Familiarity with Weblogic and Apache is a plus

Web Reference : AJF/426803965-764
Posted Date : Mon, 05 Sep 2022

To apply for this position you will complete an application form on another website provided by or on behalf of Myticas Consulting ULC. Please note IT Jobs for ColU Fans is not responsible for the application process on any external website.
Apply Here
For Remote SQL Database and Systems Administrator roles, visit Remote SQL Database and Systems Administrator Roles

********

Senior SQL DBA at Myticas Consulting ULC

Location: Chicago

Job Title: Lead SQL DBA

Role mission: Lead SQL DBA role oversees all the databases and database servers in production and test environments to make sure they’re constantly running on optimum performance. This role would also act as a gate keeper to our production environments. In addition to this, this role takes ownership of all dba related tasks and distributes those tasks accordingly to other dbas based on their capabilities.

Key Outcomes
• Dba task management: Includes receiving, evaluating, estimating and assigning all dba related tasks to other dbas.
• Collaborating with other teams on future projects and associated db activities and plan accordingly.
• Oversee monitoring activities on the website database and other DBs and establish benchmarking for performance.
• Predict future performance based on new projects and upcoming events using the performance data collected.
• Maintain and monitor SQL Server Databases while maximizing availability of critical business data.
• Ensure proper DR and HA policies are in place and they’re actually followed.
• Oversee required actions to make sure all servers are patched, and the latest service pack has been applied to all the servers while maintaining an effective communication on Server Maintenance and build activities and issues.
• Manage cloud databases including Azure SQL and AWS Redshift.
• Create scripts to automate administrative tasks.

Skills or abilities
• Strong communication skills. And willing to work in a team-oriented structure.
• Strong knowledge in relational data management, SQL Server 2008 thru 2019.
• Strong experience and knowledge over TSQL and TSQL based objects.
• Ability to identify slow running queries in and performance tune those queries.
• Identify server’s hardware bottlenecks that could affect SQL Server’s performance.
• Identify shortcomings in SSIS packages performance and address those issues.
• Work with the rest of dba team to provide around the clock support.
• Willing to learn new technologies and new tools to better monitor/manage the environments.
• Manage security on SQL Server database servers.
• database design and architecture knowledge and experience.
• Good knowledge and experience over Azure SQL DB & CosmosDB.
• SQL Replication between local SQL Servers and Azure.
• Have some knowledge over AWS Redshift and its security and performance management.
• SSRS knowledge is a plus.
• Postgres Knowledge is a big plus.

Education:
• Minimum 4 yr. degree in Systems related field or equivalent experience as a DBA/Lead DBA
• Microsoft SQL Server certification is a plus.

Web Reference : AJF/426803966-764
Posted Date : Mon, 05 Sep 2022

To apply for this position you will complete an application form on another website provided by or on behalf of Myticas Consulting ULC. Please note IT Jobs for ColU Fans is not responsible for the application process on any external website.
Apply Here
For Remote Senior SQL DBA roles, visit Remote Senior SQL DBA Roles

********

Database Engineer at Vail Systems, Inc.

Location: Chicago

Who You Are

Interested in managing opensource relational and document-oriented databases and the code that interacts with them?

As a Database Engineer you will resolve any inefficient queries that appear in the logs and initiate updates to the latest database version. You will be responsible for performing data transfers between Postgres/MySQL, Microsoft SQL Server, and MongoDB databases. You will collaborate with other highly technical engineering staff to accomplish project tasks.

What You’ll Do
• Maintain the physical data model, queries, and service interface for the loading, querying, and maintenance of data in Postgres database and other data sources. It is essential to have coding experience to be able to handle ETL processes and data validation, with either proprietary database languages or other programming languages, such as Java, Python, Scala, or Perl.
• Complete version upgrades, patching, migrations, seeding, testing, and performance monitoring.
• Optimize performance, design indexing strategies, identify patterns in MongoDB document schemas, and manage security and availability of MongoDB clusters.
• Create and execute backup design and disaster recovery plans.
• Work with project and technical managers for project planning, predict storage growth, perform database version upgrade and storage expansion.
• Define, develop, document, communicate and implement standards, processes and procedures for the Database Administration Team.
• Export data out to be loaded into our data warehouse. Improve ETL processes that interact with Microsoft SQL Servers. Write scripts and schedule jobs.

Qualifications – We encourage you to apply if you think your experience may be a match, even if you do not meet all of the qualifications.
• 2+ years of experience as a Database Administrator.
• A Bachelor’s degree in Computer Science, Computer Engineering, Data Science, or another related field.
• Proficiency administering PostgreSQL or MySQL databases.
• Understanding of SQL tuning and optimization of query plans.
• Linux shell scripting skills and experience with production Linux environments.
• Experience working with software engineers in a highly technical environment.
• Database developing and programming skills with either SQL, Java, C++, Python, Scala, or Perl.
• Excellent verbal and written communication skills.
• Experience with MongoDB replica set configuration and management, preferred.

Who We Are

At Vail, we believe in the unique power of voice interactions to create more expressive, more intimate, and more efficient interpersonal interactions. Using Vail technology, we make millions of voice interactions better every day. We process around 10% of all toll-free call traffic in the U.S; 1 in 10 times when someone calls a customer support hotline Vail is routing or interacting with that call.

We are rapidly growing across multiple dimensions, including our customer base, the scope of products we offer, and the size of our team. Now is the right time for a strong candidate to join and grow with us. We have a supportive culture where employees are encouraged to achieve both personal and team goals because we believe growth leads to both business impact and personal fulfillment.

We offer competitive compensation and affordable benefits with flexibility and choice to meet individual and family (including Domestic Partnerships) needs including:

· Multiple medical, dental, and vision plan options

· Company-paid life insurance, short and long-term disability

· 401(k) savings plan with company match (50% on first 6% of employee contribution)

· 31 days total annual PTO

· Annual Bonus Program

· Paid maternity and paternity leave

· Relocation allowance

· Employee referral bonus

· Gym membership

· Technical and Professional Development stipend

We are striving to implement and sustain an inclusive and equitable work environment for all employees by sourcing underrepresented groups and continually empowering those individuals within our organization to further enrich Vail’s communication solutions. We recognize that equitable and unique individuals benefit our teams’ problem-solving, innovation and development efforts.

COVID-19

Vail’s offices are located in Deerfield, IL, and Chicago, IL. Interviews and onboarding may be conducted remotely. We are observing a hybrid work arrangement giving employees flexibility to come into the office based on personal, team, and business needs.

< Apply Here
For Remote Database Engineer roles, visit Remote Database Engineer Roles

********

Sql server developer at UnitedHealth Group

Location: Chicago

UnitedHealthcare is a company that’s on the rise. We’re expanding in multiple directions, across borders and, most of all, in the way we think.

Here, innovation isn’t about another gadget, it’s about transforming the health care industry. Ready to make a difference?

Make yourself at home with us and start doingyour life’s best work.(sm) n nYoull enjoy the flexibility to telecommute* from anywhere within the U.

S. n nas you take on some tough challenges. n nPrimary Responsibilities : n* Identifies solutions to non-standard requests and problems n* Solves moderately complex problems and / or conducts moderately complex analyses n* Works with minimal guidance;

nseeks guidance on only the most complex tasks n* Translates concepts into practice n* Provides explanations and information to others on difficult issues n* Coaches, provides feedback, and guides others n* Acts as a resource for others with less experience n n nYoull be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

n n nRequired Qualifications : n* Undergraduate degree or equivalent experience n* 3+ years of experience in analytical roles (e.

g. business analysis, data analytics) n* 3+ years of experience with SQL Server n* 2+ years of experience with SSIS / ETL n* 2+ years of experience with MS Access n nPreferred Qualifications : n* Solid communication skills, abilityto work with stakeholders from multiple levels and disciplines n* Ability to summarize information and communicate upstream and downstream n* Capacity to work in a fast-paced environment n* Ability to work independently and in a team environment to deliver n* Demonstrated ability to prioritize, multi-task, and problem solve n nTo protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies now require all employees to disclose COVID-19 vaccination status prior to beginning employment.

n nIn addition, some roles require full COVID-19 vaccination as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance.

n nCandidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment.

n nNow, add your energy, your passion for excellence, your near-obsession with driving change for the better. Get the picture?

UnitedHealthcare is serving employers and individuals, states and communities, military families and veterans where ever they’re found across the globe.

We bring them the resources of an industry leader and a commitment to improve their lives that’s second to none. n nThis is no small opportunity.

It’s where you can doyour life’s best work.(sm) n n*All Telecommuters will be required to adhere to UnitedHealth Groups Telecommuter Policy.

n nColorado, Connecticut or Nevada Residents Only : The salary range for Colorado residents is $66,100 to $118,300. The salary range for Connecticut / Nevada residents is $72,800 to $129,900.

n nPay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).

n nNo matter where or when you begin a career with UnitedHealth Group, youll find a far-reaching choice of benefits and incentives.

n n nDiversity creates a healthier atmosphere : UnitedHealth Group is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

n n n nUnitedHealth Group is a drug – free workplace. Candidates are required to pass a drug test before beginning employment.

Last updated : 2022-09-05
Apply Here
For Remote Sql server developer roles, visit Remote Sql server developer Roles

********

The Tech Career Guru
We will be happy to hear your thoughts

Leave a reply

Tech Jobs Here
Logo