The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

Senior Database DBA | Architect (Remote)

Job Description


SQL Server DBA | Architect
The Senior MSSQL Database Administrator reviews, evaluates, designs, implements, and maintains company database(s) associated with their financial software products, as well as identifies data sources, constructs data decomposition diagrams, provides data flow diagrams, and documents the process.

Responsibility:

  • Designs schema changes and other components in tandem with other DBAs and/or team members and assesses potential impact to the production environment.
  • Assists with production design, administration, and support of large MSSQL databases for financial applications.
  • Provides database support, including on-call responsibility and unscheduled off-hour support.
  • Implements database changes and proactively identifies issues to prevent outages.
  • Participates in application development projects to evolve database architecture and design, including analysis of developer-created SQL for performance and correctness.
  • Develops SQL as necessary for use in development of applications, as well as generating reports of business domain data.
  • Designs schema changes and other components in tandem with other DBAs and/or team members and assesses potential impact to the production environment.
  • Works closely with other departments to ensure platform stability and optimal database performance.
  • Assists with the performance, analysis, and tuning of the staging and production database instances.
  • Creates clear documentation of operating procedures, database object layout, work flow diagrams, and specifications for developed databases.
  • Provides and designs tools and scripts to assist with data analysis, problem diagnosis, strategic planning, and the management of the database and transaction processing environment.
  • Assists with the design, implementation, documentation, and monitoring of backup/recovery procedures.
  • Assists in the development of a methodology for the ongoing assessment of database performance and the identification of problem areas.
  • Database Reporting using various reporting tools such as Telerik Reporting, SSRS, and Crystal Reports.


Experience:

  • Minimum 6+ years of experience with MSSQL relational databases and high-volume transaction processing systems, preferably in a custom software development environment, with at least one year in large data environment.

Job Requirements

 

Job Snapshot

Location US-GA-Addison
Employment Type Full-Time
Pay Type Year
Pay Rate $125,000.00 - $145,000.00 /Year
Store Type IT & Technical
Apply

Company Overview

Analysts

Analysts International Corporation (AIC) is an IT services firm fully dedicated to the success and satisfaction of its customers. From IT staffing to project-based solutions, AIC provides a broad range of services designed to help businesses and government agencies drive value, control costs and deliver on the promise of a more efficient and productive enterprise. Learn More

Contact Information

US-GA-Addison
AIC
Snapshot
Analysts
Company:
US-GA-Addison
Location:
Full-Time
Employment Type:
Year
Pay Type:
$125,000.00 - $145,000.00 /Year
Pay Rate:
IT & Technical
Store Type:

Job Description


SQL Server DBA | Architect
The Senior MSSQL Database Administrator reviews, evaluates, designs, implements, and maintains company database(s) associated with their financial software products, as well as identifies data sources, constructs data decomposition diagrams, provides data flow diagrams, and documents the process.

Responsibility:

  • Designs schema changes and other components in tandem with other DBAs and/or team members and assesses potential impact to the production environment.
  • Assists with production design, administration, and support of large MSSQL databases for financial applications.
  • Provides database support, including on-call responsibility and unscheduled off-hour support.
  • Implements database changes and proactively identifies issues to prevent outages.
  • Participates in application development projects to evolve database architecture and design, including analysis of developer-created SQL for performance and correctness.
  • Develops SQL as necessary for use in development of applications, as well as generating reports of business domain data.
  • Designs schema changes and other components in tandem with other DBAs and/or team members and assesses potential impact to the production environment.
  • Works closely with other departments to ensure platform stability and optimal database performance.
  • Assists with the performance, analysis, and tuning of the staging and production database instances.
  • Creates clear documentation of operating procedures, database object layout, work flow diagrams, and specifications for developed databases.
  • Provides and designs tools and scripts to assist with data analysis, problem diagnosis, strategic planning, and the management of the database and transaction processing environment.
  • Assists with the design, implementation, documentation, and monitoring of backup/recovery procedures.
  • Assists in the development of a methodology for the ongoing assessment of database performance and the identification of problem areas.
  • Database Reporting using various reporting tools such as Telerik Reporting, SSRS, and Crystal Reports.


Experience:

  • Minimum 6+ years of experience with MSSQL relational databases and high-volume transaction processing systems, preferably in a custom software development environment, with at least one year in large data environment.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Senior Database DBA | Architect (Remote) Apply now