Senior Database Administrator

4 weeks ago

Chicago, United States Hinshaw & Culbertson Full time
SENIOR DATABASE ADMINISTRATOR

Location: Flexible and in any state where the firm has an office.

Hinshaw & Culbertson LLP, a national law firm, currently has an excellent full-time employment opportunity for a Senior Database Administrator. We offer competitive compensation and an excellent benefits package.

POSITION SUMMARY:
Looking for a Senior Database Administrator to join our team to apply system analysis techniques and procedures, including consulting with users, to determine software and system specifications for, and coordinates the design, implementation, production support and troubleshooting for SQL servers and all databases in an integrated system in multiple locations. Both domestic and international, the Senior Database Administrator will implement systems technologies covering all users to ensure high-availability of the SQL server environments.

ESSENTIAL FUNCTIONS INCLUDE:
•Develops database standards and specifications, applies database systems analysis techniques and procedures to design, develop, implement, maintain and support databases throughout the Firm.
•Works closely with IT staff to evaluate and install new applications and integrate them into the SQL server. Creates reviews and edits SQL code. Coordinates team members to ensure collaborative efforts result in maximum efficiency. May be required to develop, design, maintain and support database based software applications.
•Maintains SQL Server client and server software to current stable service pack levels. Creates test environment and tests service packs prior to their installation in the production environment.
•Tests, corrects errors, and modifies changes to programs or to databases. Reviews project requests describing database user needs, estimating time and cost required to complete project. Selects and enters codes to monitor database performance and to create production database. Coordinates with programmers and analysts to make changes to database management system. Reviews workflow charts developed by programmer analyst to understand tasks computer will perform. Reviews procedures in database management system manuals for making changes to databases. Confers with coworkers to determine scope and limitations of projects. Revises definition of data as defined in data dictionary. Specifies user and user access levels for each segment of databases.
•Documents operating procedures and database design specifications for applications to be developed.
•Serves as a liaison with vendors on the implementation of new packaged systems or upgrades to existing systems.
•Create data feeds between applications and for import/export to external entities or to the cloud. Tools can include: SQL Server Integration Services (SSIS), SQL Stored Procedures, Batch files, Winscp, Powershell, and various APIs.
•Creates data warehouses and designs data integration processes. Writes logical and physical database descriptions, including location, space, access method, and security. Establishes and calculates optimum values for database parameters. Develops data model describing data elements and how they are used. Codes database descriptions and specific identifiers of database to management system, or directs others in coding descriptions.
•Oversees server roles and database security procedures to control data access and server privileges.
•Sets up and manages backups, log shipping and recovery. Monitor database backups using Ola Hallengren's scripts or Idera SQL Safe
•Programs scripts for database monitoring and automating routine tasks.
•Periodically reviews server disk capacity and usage to ensure proper database growth and determine the necessity for server expansion to ensure adequate database capacity Firm-wide.
•Proactively maintains and expands knowledge of trends, developments and new technologies that impact database design and operations. Researches, evaluates and provides input on database products and researches, evaluates and recommends enhancements to current systems and methods of operating.
•Responsible for designing, implementing and maintaining the highest level of security of all Firm records and files.
•Supports off hours (evening, weekends and holiday) installations and upgrades as needed.
•Participates in departmental project teams and task forces designed to streamline workflow and/or resolve issues; assists with various firm and/or departmental projects and initiatives as assigned.
•Working with a requestor, creates reports using SQL Server Reporting Services (SSRS)
•Assumes additional responsibilities as requested.

QUALIFICATIONS AND PRIOR EXPERIENCE:
•Bachelor's Degree in computer science or equivalent technical knowledge. Microsoft Certified Database Administrator Certification preferred.
•7-10 years of database experience.
•Comprehensive knowledge of database administration and system analysis including design, installation and troubleshooting of MS SQL server on Windows server platforms. Experience using SQL server monitoring tools.
•Thorough command of the industry language and the ability to effectively communicate technical information to a variety of technical and non-technical users.
•Strong analytical and problem solving skills, ability to organize and prioritize multiple assignments, use initiative and judgment to accomplish results, participate as a team leader or member of a team, work under pressure and complete job assignments in an accurate, timely and professional manner.
•Excellent presentation, communication, interpersonal and customer service skills and ability to interact effectively and professionally with all learning styles, personality types and levels of management, staff and a variety of external entities including clients and prospective clients of the Firm.
•Ability to travel to the Firm's other offices.

This job description is intended to describe the general nature and level of the work being performed by employees in this job. It is not intended to be a complete list of all responsibilities, duties, and skills required for this job classification.

As an EEO/AA employer, Hinshaw & Culbertson LLP will not discriminate in its employment practices due to an applicant's age, race, color, religion, sex, sexual orientation, gender, gender identity, gender expression, national origin, protected veteran or disability status or any other factor prohibited by law.

  • Senior Database Administrator

    4 weeks ago

    Chicago, United States Canadian Imperial Bank of Commerce Full time

    Senior Database Administrator page is loaded Senior Database Administrator Apply locations Chicago, IL time type Full time posted on Posted Yesterday job requisition id 2408709 We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients. At CIBC, we...

  • Senior Database Administrator

    1 week ago

    Chicago, United States Canadian Imperial Bank of Commerce Full time

    Senior Database Administrator page is loaded Senior Database Administrator Apply locations Chicago, IL time type Full time posted on Posted Yesterday job requisition id 2408709 We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients. At CIBC, we...

  • Senior Database Administrator

    2 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...

  • Oracle Database Administrator

    1 month ago

    Chicago, United States The Brixton Group, Inc. Full time

    3 weeks ago Be among the first 25 applicants Leads the design, development, delivery, and optimization of databases, database instances, database clusters, database software, and related components. Conducts Oracle application system reviews to optimize application performance and efficiency. Serves as the senior subject matter expert and technical lead for...

  • Senior Database Administrator

    4 weeks ago

    Chicago, United States CIBC Full time

    We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients. At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are...

  • Senior Database Administrator

    3 weeks ago

    Chicago, Illinois, United States TEKsystems Full time

    TEKsystems is looking for a strong DBA to help one of our clients in Chicago. This is a 100% remote opportunity and long term. Skills:Database administrator, Sql server, Oracle, postgresql, aurora postgres, aurora storage volumeDescription:One Postgres/ Aurora Postgres Sr.DBA • 8-11 years of PostgreSQL DBA experience• Experience working with community...

  • Senior Database Administrator

    3 weeks ago

    Chicago, Illinois, United States TEKsystems Full time

    TEKsystems is looking for a strong DBA to help one of our clients in Chicago. This is a 100% remote opportunity and long term. Skills:Database administrator, Sql server, Oracle, postgresql, aurora postgres, aurora storage volumeDescription:One Postgres/ Aurora Postgres Sr.DBA • 8-11 years of PostgreSQL DBA experience• Experience working with community...

  • Database Administrator

    5 days ago

    Chicago, Illinois, United States Saxon Global Full time

    Here's a fantastic opportunity as a Database Administrator at a leading company!Position: Database AdministratorLocation: Remote; Ideally hybrid onsite in Boston, MADuration: 6+ MonthsOverview:Creates and maintains databases for test, development, and production environments.Analyzes, tests, and implements physical database design.Documents environment and...

  • Database Administrator

    3 weeks ago

    Chicago, United States Saxon Global Full time

    Opportunity for a Database Administrator. Here are the details: Position: Database Administrator Location: Remote; Ideally hybrid onsite in Boston, MA Duration: 6+ Months Overview: Creates and maintains databases for test, development and production environments. Analyzes, tests, and implements physical database design. Documents environment and...

  • Database Administrator

    3 weeks ago

    Chicago, United States Channel Partners Group Full time

    A professional Database Administrator will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both the backend data structure and front-end accessibility for end-users. **Responsibilities**: - Build database systems of high availability and quality depending on each end...

  • Database Administrator

    2 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, designs, implements, administers and maintains the District’s relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of...

  • Database Administrator

    4 weeks ago

    Chicago, United States Performix Full time

    **Job Description: **Database Engineer Responsibilities and Duties: - Assist in design and development of distributed database systems. - Optimize database systems for performance and reliability. - Perform database maintenance and troubleshooting activities. - Test database systems and perform bug fixes. - Provide database solutions based on technical...

  • Database Administrator

    2 weeks ago

    Chicago, United States Na Oiwi Kane Full time

    **JOB DESCRIPTION** **Position Title**:Database Administrator **Location**:80% Remote, 20% Chicago, IL **Introduction**: Rivet Operations Company (“Rivet”) has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) providing IT Support Services. Rivet is an exceptional industry partner to...

  • Database Administrator

    4 weeks ago

    Chicago, United States RIVET OPERATIONS COMPANY LLC Full time

    JOB DESCRIPTIONPosition Title: Database Administrator Location: 80% Remote, 20% Chicago, IL Introduction: Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) providing IT Support Services. Rivet is an exceptional industry partner to the Department of...

  • Database Administrator

    4 weeks ago

    Chicago, United States RIVET OPERATIONS COMPANY LLC Full time

    JOB DESCRIPTION Position Title: Database Administrator Location: 80% Remote, 20% Chicago, IL Introduction: Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) providing IT Support Services. Rivet is an exceptional industry partner to the Department of...

  • Senior Manager – Oracle

    2 weeks ago

    Chicago, United States United Airlines Full time

    Description There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in hundreds of...

  • Senior Manager

    2 weeks ago

    Chicago, United States United Airlines Full time

    Job DescriptionDescriptionThere’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in...

  • Database Administrator

    4 weeks ago

    Chicago, United States The University of Chicago Full time

    Department BSD BIS - Business Intelligence Services About the Department About the Department The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and translational research, education, and patient care come together in a single campus. Its mission is to create new knowledge of living systems,...

  • SQL Database Administrator

    4 weeks ago

    Chicago, United States TechCoreGlobal Full time

    **Title: SQL DBA** **Location: Chicago, IL (Onsite - Open for relocation )** **Good SQL DBA skills, having some experience of doing TDE data base encryption & automations in the DBA space.** **Responsibilities**: - Manage and maintain SQL databases including PostgreSQL, Oracle, DB2, MySQL, and Microsoft SQL Server. - Implement encryption protocols to...

  • Database Administrator

    5 days ago

    Chicago, Illinois, United States RedMane Technology Full time

    Database Administrator – Chicago Company DescriptionRedMane Technology LLC is an application software consulting and systems integration company based in Chicago. We deliver software solutions for our clients throughout the United States and Canada by means of building new applications, implementing cloud and packaged systems, and/or modernizing legacy...