SQL Database Support and Reporting Specialist

MIAC Analytics

Location: Charlotte, North Carolina

Please click here to view the application link

Position Responsibilities

  • Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems.
  • Create ad-hoc reports using SQL and other scripting languages per requirements from the database.
  • Analyze troubleshoot and remediate data integrity issues.
  • Monitor systems; proactively manage and maintain configurations to ensure performance and availability.
  • Perform database and related asset backups and recovery.
  • SQL query optimization; index management.
  • System performance and optimization tuning.
  • Support production systems for database problem resolution, recovery and Emergency off-hour support.
  • Provides analytical and troubleshooting abilities to address multiple technical areas of systems.
  • Works independently on assignments where considerable judgment and initiative are required in resolving problems and making choices, recommendation or decisions
  • Provides analytical and troubleshooting abilities to address multiple technical areas of systems.
  • Train on MIAC proprietary financial risk management and data management systems in order to provide support and understand the data management processes that must be optimized and maintained.

Desired Skills

The candidate should have working knowledge of a variety of concepts, practices, and procedures including:

  • Experience with SQL Replication and Service Broker.
  • Experience in database design, development, implementation, and methodologies for Data warehouses and OLTP business systems.
  • Ability to examine and optimize query execution plans and index/data usage.
  • Experience analyzing hardware, software, network ecosystems to optimize database server performance.
  • Comprehensive knowledge of Transact SQL, Stored procedures, Views, Triggers, Functions.
  • Experience automating data Import/Extraction using SQL Server tools such as SSIS, BCP, bulk insert.
  • Experience resolving to lock, deadlock issues.
  • Developed SQL databases.
  • Performed development tasks of designing tables, storing procedures, views and functions.
  • Experience with Microsoft Reporting and Analysis Services.
  • Ability to work with internal customers, including the ability to read and interpret what the internal customer is saying to proactively identify potential issues and problems and advise the internal customer on best practices and/or be able to suggest and deliver product enhancements
  • Ability to multi-task and manage several tasks simultaneously while working both independently and in group environments
  • Ability to communicate and work effectively with external clients and vendors on data integrations and database configurations for MIAC systems.

Job Type: Full-time
Job Location: Charlotte, North Carolina
Required Education: Bachelor’s
Required experience: 2+ years

Please click here to view the application link
Contact Here

About MIAC

Since 1989, MIAC has been at the forefront in providing:

  • Secondary Pricing and Risk Management Software and Advisory Solutions
  • MSR, Whole Loan, Residual and Illiquid Mortgage Pricing, Hedging, and Accounting
  • Software and Advisory Solutions
  • MSR and Whole Loan Brokerage Services
  • Interest Rate Derivative Pricing Software and Pricing Services
  • Pricing Software and Pricing Services for Mortgage Derivatives

MIAC Analytics™ is used to value over four trillion dollars in mortgage whole loans, MSR (mortgage servicing rights), residuals, and interest rate derivatives on a monthly basis by the majority of the largest mortgage companies in the industry.

MIAC’s corporate headquarters is located in New York City, with additional offices in Charlotte, NC, Bethlehem, PA, Bengaluru, India, and London.

Posted in Jobs.