1872 Consulting
SQL DBA
1872 Consulting, Chicago, Illinois, United States, 60290
SQL DBChicago, IL (loop) 2 days onsite, 3 days work from home
What you'll be doing
Optimize stored procedures, functions and ad-hoc SQLDesign, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systemsImplement, create reports and provide general support for SQL Server Reporting servicesMonitor relational databases to optimize performance, resource use, backup/recovery, and physical implementationReview database objects and create and maintain change controlsMonitor and maintain database securityMigrate databases between servers and various platformsAnalyze and resolve SQL Server faultsDocument data flows, application specifications from a DB perspective and system proceduresImplement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shippingSupport highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)Investigate and resolve reported application issues, escalating issues as necessary to the application ownersProvide 24x7 on-call support on a rotating basisFlexible to work off-hours, as requiredSkills we're seeking
5+ years of experience as a SQL DBAStrong SQL Server experienceExperience in the following DBA areas (all not required, more the better):
Performance management and tuning, including identifying solutions that optimize SQL execution plansTriggersStored Procedure Code Development and StandardizationData Integration and MigrationManagement StudioSQL XMLDatabase Auditing and Controls
Nice to haves
Experience with Azure SQLExperience with physical and VMWare SQL configuration from an infrastructure perspectiveExperience with Ability to translate Logical Data Models into physical structures
What you'll be doing
Optimize stored procedures, functions and ad-hoc SQLDesign, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systemsImplement, create reports and provide general support for SQL Server Reporting servicesMonitor relational databases to optimize performance, resource use, backup/recovery, and physical implementationReview database objects and create and maintain change controlsMonitor and maintain database securityMigrate databases between servers and various platformsAnalyze and resolve SQL Server faultsDocument data flows, application specifications from a DB perspective and system proceduresImplement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shippingSupport highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)Investigate and resolve reported application issues, escalating issues as necessary to the application ownersProvide 24x7 on-call support on a rotating basisFlexible to work off-hours, as requiredSkills we're seeking
5+ years of experience as a SQL DBAStrong SQL Server experienceExperience in the following DBA areas (all not required, more the better):
Performance management and tuning, including identifying solutions that optimize SQL execution plansTriggersStored Procedure Code Development and StandardizationData Integration and MigrationManagement StudioSQL XMLDatabase Auditing and Controls
Nice to haves
Experience with Azure SQLExperience with physical and VMWare SQL configuration from an infrastructure perspectiveExperience with Ability to translate Logical Data Models into physical structures