SQL Database Administrator

The Tri-Com Consulting Group
is a Full-Service IT Employment Consulting Firm who is seeking qualified candidates for the following opening:

SQL Database Administrator

• Hands on experience of the role as DBA. Experience in creating Jobs, Alerts, SQL Server Mail Agent, Log setting, and Active directory user access.
• Strong experience with data warehousing.
• Experience in the design and development of Transact-SQL,
• Database Backup and Recovery,
• Performance management, troubleshooting and tuning,
• The ability to do ad-hoc SQL to research data questions, identify root causes and interact closely with peers and business users is essential.
• Understand entire data life cycle migration, development, transformation, maintain, virtualization and visualization
• Experience installing, configuring, managing, monitoring and troubleshooting SQL Server.
• Comprehensive knowledge and experience of using Business Intelligence (SSIS, SSRS, SSAS) and SQL Server together to realize the business requirements.
• Highly experienced in Data Transformation Services, creating complex ETL packages and ETL configuration by using SQL Server Integration Services (SSIS).
• Highly experienced in data lineages and troubleshooting with the knowledge of software coding, database, data virtualization and data visualization.
• Expertise in using SQL Server to create Tables, Views, Stored Procedures, Functions, Indexes, Cursors and Triggers.
• Experienced with ETL package configuration and error handling.
• Experience in Designing, Creating and deploying and Processing of Cubes using SSAS.
• Experience in writing Multidimensional Expressions (MDX) and using MDX queries in report generation. Experience developing complex MDX queries.
• Highly experienced in data visualization. Hands on experience on developing Custom Reports and different types of Tabular Reports, Matrix Reports, parameterized, drill through and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Good knowledge on Data Security by using combination of user id and stored procedure/function/view in the reports.
• Proficient in creating Standard Subscriptions and Data Driven Subscriptions for delivering reports by email or stored on drives.
• Experience in build and maintain web app with Angular, ASP.NET Core, MVC and Entity Framework.
• Experience in IIS configuration, publishing web services and power shell command line script.
• Experience on server maintenance. Hands on experience of managing SQL server configuration. Fully conduct any SQL server upgrades.
• Experience in DeveOps as sprint tool for version control, creating pipelines and user stories.
• Excellent Agile team player and familiar with sprint and scrum team practice.

~Tri-Com is an Affirmative Action/Equal Opportunity Employer~ We strongly encourage the applications of women, minorities, persons with disabilities, and military veterans. As a condition of employment you will be required to pass a drug screening and other background checks including past employment and confirmation of technical certifications.