| IL Local :: 5+ yrs SQL DBA :: No CPT at Chicago, Illinois, USA |
| Email: [email protected] |
| From: Anamika, RCI [email protected] Reply to: [email protected] Title: SQL Server Database Administrator Location: Chicago, IL [ 1 day onsite/ month] Need Local Duration: 6+ Months Visa - No CPT Description : We are looking for someone early in their career as a DBA. Could be a help desk, db developer etc that has some experience supporting the databases and has some experience. Looking for some experience with backups, indexes, trouble shooting. Experience must be called out on resume. What we aren't looking for: individuals with 5 or 10 years experience or a new college grad with no experience . Team: 1 senior that this individual would learn from. Be the backup, do patching etc. Cloud : 50% there now. Intent to move rest of On prem to cloud. Would get to be a part of this. Selling points for role and NCSBN : Position is mostly remote, maybe once a month in the office. Look in surrounding states to IL. Must be willing to come/travel on site as needed. Why work for Ncsbn a very stable organization. Most people in IT have been there 5 years plus, Work with state governments- they are not impacted by tech bubbles, layoffs etc. Career growth- this individual will be trained by a senior DBA. Interview process : Positive resume review will lead to a 30 minute assessment. It is technical, not behavioral. Successful assessment leads to 1 hour Teams interview with mgr and DBA. NOTE : HM OOO next week. Resume review: Week of 8/7 Job Opportunity Assists with and supports the design, development, installation, configuration, upgrade, administration, monitoring and maintenance of corporate database environments utilizing a cloud-first approach. Aids in the management of databases hosted on-premises and hosted on cloud infrastructure-as-a-service (IaaS) and cloud platform-as-a-service (PaaS) products. Installs database software service packs, security updates, and cumulative updates as necessary. Partners with senior database administration staff to identify and mitigate risk to eliminate or minimize impact on the organization. Provides continuous improvement analysis and action. Follows and enforces rules and guidelines for the development of SQL objects. Optimizes indexes and tables. Maintains database dictionaries and schema documentation. Assists with the design and deployment of data table structures, triggers, functions, stored procedures and views. Creates queries and reports. Resolves database access and performance issues. Executes strategies to maximize database security, availability, compliance, and performance including replication, archiving, log shipping, backup, recovery, and high availability. Assists with the development of database disaster recovery processes and procedures. Participates in disaster recovery testing. Monitors and conducts performance tuning of database systems. Participates in project team meetings with business analysts, quality assurance analysts, developers, and senior database administration staff to determine requirements for database design. Partners with senior database administration staff to determine procedural changes and/or modifications to the database environments. Facilitates system integration assistance through database design. Assists with database application upgrades. Collaborates with the infrastructure team and senior database administration staff on database server and network issues. Communicates promptly and proactively. Follows and enforces database security guidelines. Enforces appropriate database access control levels. Adheres to database security standards and guidelines. Assists with audits. Maintains database server and application tools that support the database environment. Evaluates and makes recommendations of new database products in accordance with the needs of the business. Required Skills and Experience Bachelors degree in computer science/information systems or equivalent and applicable job experience required. Minimum three years of progressive information technology experience. Minimum two years of on-premises and/or cloud database administration experience. Knowledge of database backups, recovery, security, and integrity of database servers in cloud and on-premises environments General relational database concepts (tables, columns, rows, primary keys, foreign keys, indexes) SQL Server database objects (tables, views, synonyms, functions, stored procedures, triggers) SQL Server security (logins, users, groups, roles, permissions, encryption) SQL Server maintenance (scheduled jobs, maintenance plans, index rebuilds, backups, restores) Preferred Skills and Experience : SSIS, SSRS, SSAS; Azure SQL Database, Azure SQL Managed Instance; PowerBI,T SharePoint, .NET/C#; Azure Data Lake, Azure Data Factory, Azure Databricks; Azure certifications. Keywords: csharp database information technology Illinois |
| [email protected] View all |
| Thu Jul 27 20:55:00 UTC 2023 |