See more Collapse

Senior Database Administrator

1 month 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. #J-18808-Ljbffr

We have other current jobs related to this field that you can find below

  • Senior Database Administrator

    3 weeks ago

    Chicago, United States Barrow Wise Consulting, LLC Full time

    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today. Responsibilities:...

  • Senior Database Administrator

    4 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...

  • Senior Database Administrator

    2 weeks ago

    Chicago, United States Brooksource Full time

    PostgreSQL Database Administrator6-Month Contract-to-HireRichardson, TX OR Chicago, ILOur Fortune 500 health insurance client is hiring a PostgreSQL DBA to support their Claims Modernization effort. In this role, you will be responsible for migrating their applications to PostgreSQL to enhance their claims processing capabilities by improving operational...

  • Database Administrator

    1 day ago

    Chicago, United States Stash Talent Services Full time

    Role: Snowflake AdministratorLocation: Chicago, IL (Hybrid)Duration: 12 months contractJob DescriptionDatabase Administration and ManagementManage and administer Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Implement and maintain database security by creating roles, users, and managing...

  • Database Administrator

    1 month ago

    Chicago, United States O'Reilly Auto Parts Full time

    A Database Administrator I, is responsible for the performance, integrity and security of the databases to support the computing environment. Under direct supervision, a Database Administrator I will work through day-to-day operational tasks related to the database systems.The salary for this role is from 105k to 130k, most offers however will be around the...

  • Database Administrator

    3 weeks ago

    Chicago, United States O'Reilly Auto Parts Full time

    A Database Administrator I, is responsible for the performance, integrity and security of the databases to support the computing environment. Under direct supervision, a Database Administrator I will work through day-to-day operational tasks related to the database systems.The salary for this role is from 105k to 130k, most offers however will be around the...

  • Database Administrator

    4 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

    2 months ago

    Chicago, United States NinjaTrader Full time

    Job DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...

  • Database Administrator

    2 months ago

    Chicago, United States NinjaTrader Full time

    NinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team...

  • Database Administrator

    2 months ago

    Chicago, Illinois, United States NinjaTrader Full time

    NinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team finds...

  • Senior Manager – Oracle

    3 months 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...

  • Database Administrator

    1 week ago

    Chicago, United States Taft Stettinius & Hollister LLP Full time

    Taft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office. Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...

  • Database Administrator

    1 week ago

    Chicago, Illinois, United States Taft Stettinius & Hollister LLP Full time

    Taft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office.Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...

  • Oracle Application Database Administrator

    2 weeks ago

    Chicago, United States Oreva Technologies, Inc. Full time

    Job Title: Senior Oracle Applications DBA.Location: Remote role in Chicago, IL (Local Only)Job Summary: The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position is responsible for researching and troubleshooting application and database issues for the...

  • Oracle Application Database Administrator

    2 weeks ago

    Chicago, United States Oreva Technologies, Inc. Full time

    Job Title: Senior Oracle Applications DBA.Location: Remote role in Chicago, IL (Local Only)Job Summary: The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position is responsible for researching and troubleshooting application and database issues for the...

  • MySQL Database Administrator

    2 months ago

    Chicago, United States Venture Search Full time

    MySQL DBA Chicago or Remote (For US Citizens Only) 115K USD - 150K USD base + bonus Our client, a top-tier proprietary trading firm is currently looking to hire a MySQL Database Administrator to expand their DBA team; this role can be located out of their Chicago office or be remote. Currently, they are going through an exciting revamp and our in the...

  • Database Administrator V

    3 weeks ago

    Chicago, United States Saxon Global Full time

    Job Title: AWS Redshift DBA Work Location: Required to be onsite 2 days a week Seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with Query Tuning. Responsibilities • Experience: 8 to 10 years as a DBA that...

  • Senior Database Administrator

    1 week ago

    Chicago, Illinois, United States Belvedere Trading Full time

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded funds (ETF), and equity index options. From the beginning, we began iteratively...

  • Database Administrator

    1 month ago

    Chicago, United States HUB International Full time

    ABOUT USAt HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees resources in...

  • Database Administrator

    3 weeks ago

    Chicago, United States RedMane Technology Full time

    Job Description Database Administrator - Chicago Company Description RedMane 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...