Data Base Administrator Job Description Sample
Data Base Administrator
Title: Database Administrator
Location: Denver, CO 80202
Duration: 8 months
"U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time."
Responsible for database design, database implementation, and database administration using database management systems (DBMS) in a complex mainframe or network-based environment, similar in size and complexity to the client-server environment or web application, with skills in problem analysis, testing, and performance tuning.
Knowledge and Skill sets include :
Oracle 12c (184.108.40.206) database administrator / developer
AWS / RDS
Oracle database security
Unix shell scripting
Oracle patching experience
RMAN / datapump
Performance Tuning (ASH, AWR, ADDM)
Worked with tools such as SQL Developer, Toad, SQL*Plus
Some experience with database design and ETL
Some experience with JDBC
Work in an environment with the ability to complete tasks under tight deadlines with limited supervision.
Be able to make decisions quickly
Needs to work well in a collaborative team environment
Minimum experience of 3 years is required.
Data Base Administrator - Surgical Services
Responsible for and coordinate all Metabolic/Bariatric Surgical and Joint Replacement database activities.
Ensures data is accurate, complete and timely submission through high-quality data compilation and documentation.
Identify gaps of discrete data elements to support EMR builds as needed.
Identifies and recommends areas for improvement with relevant processes and operating procedures. Learns and utilizes new software applications as appropriate.
Accesses and assembles appropriate educational resources for personal use and for availability to others.
Prepares and generates reports from Registry databases and provide data and statistical information to administrators, physicians and others
Serves as the liaison between the registry and other Carle departments.
Assesses and problem solves using information systems and process to promote desired patient, professional and organizational outcomes. Participates in quality initiatives as needed.
Collect and submit accurate, complete, and timely data to assigned registries.
Communicate opportunities for clinical improvement to all levels of staff and providers as needed
Support performance improvement efforts as needed
Direct and coordinate all aspects of the Bariatric Surgery and Ortho/Joint registry functions, including data collection, data submission, daily quality report issues, outcomes report review and analysis, and communication/presentation of opportunities for improvement. Support Performance Improvement efforts as needed. Assume leadership and facilitation role with facility physicians, staff, and administrative personnel.
Data Base Administrator 2
Ohio Department of Public Safety
- Information Technology
Report in location: 1970 West Broad Street, Columbus, Ohio 43223
Work hours: 8:00am
- 5:00pm (May be on call 24/7)
Provides technical support of all ODPS SQL Server DBMS on windows operating system & supporting database software (e.g. SQL Server Management Studio, Query Store, SQL Profiler, Replication, Indexing, SSIS packages & data modeling and reporting tools); performs installation, maintenance, debugging, troubleshooting, backup/restore, disaster recovery & tuning of multiple very large, very complex databases (i.e., multiple SQL Server machines supporting multiple SQL Server instances) in standalone and distributed environments; Provide some support of & technical expertise in Oracle; Responds to database problems in a swift, professional & courteous manner; Confers with vendors to resolve problems; Works with vendors in acquiring product information & services to support new & existing systems; Ensures coverage for &/or responds to database issues 24 hours/day, 7 days/week, 365 days/year, which may require call back or on call; Establish priorities & supervise subordinate supervisory personnel (e.g. provide developmental opportunities & work direction, coach staff to foster development, monitor staff activities to ensure quality customer service & information technology security, evaluate performance, approve section staffing levels, recommend discipline, pre-screen applications & participate in interviews).
Serves as the strongest & most experienced overall data warehouse technical resource; Owns & resolves the most difficult analysis objects and procedures; Advises ODPS IT leadership as required on database reporting and analysis specific strategy (e.g. able to describe technical issues in business terms); Experienced in the use of "big data" technologies such Hadoop, Pig, or Hive. Strong familiarity with statistics and statistical concepts such testing, significance and clustering; Work with business unit customers to create data objects in SQL Server Analysis Services for use with tools such as MS Excel, Tableau, Cognos and Informatica; Plans & attends meetings to facilitate sharing of information between database analyst staff, technical services staff & others; Designs and develops ETL processes to move data from OLTP sources to SQL Server Analysis Server objects in accordance with business needs; Works to create and maintain data warehouse solutions.
Performs all aspects of database management for departmental enterprise database systems, including database administration, database security, and data normalization (conceptual and physical design) of database systems (e.g. SQL Server on Microsoft Windows operating system platform); Acts as group leader of departmental database technicians/analysts in modification &/or design of databases (e.g. develops & maintains database security, executes database auditing and change management procedures & participates in advance phases of database design).
Collaborates with other IT technical staff (e.g. database analysts, programmers and systems technical staff) and consultants in design & implementation of data warehouse solutions; Serves as database administration lead in working with other teams on application specifications & system enhancements to ensure appropriateness of security and design specific to enterprise class, very large database configurations; Leads implementation of standards and best practices for data warehousing and data management including naming standards and authoritative data set determination.
Completion of undergraduate core program in computer science or associate degree in computer information science; 7 yrs. exp. in systems analysis & design & computer programming using COBOL &/or other high-level programming language, of which 2 yrs. was as team/project leader.
Or completion of undergraduate core program in computer science or associate degree in computer information science; 4 yrs. exp. in design & maintenance of data base management system executing under one platform, of which 2 yrs. was at team/project leader; 2 yrs. exp. in computer programming using COBOL &/or other high-level languages.
Or 3 yrs. exp. as Data Base Analyst 3, 64153.
Or 2 yrs. exp. as Data Base Analyst 4, 64154
Or 12 mos. exp. as Data Base Analyst 5, 64155.
Or 12 mos. exp. as Data Base Administrator 1, 64156.
Or equivalent of Minimum Class Qualifications For Employment noted above.
Agency Preferred Minimum Qualifications
36 months experience installing & utilizing SQL Server Analysis Services (SSAS) for database projects in an enterprise environment and 24 months experience installing & utilizing SQL Server Integration Services (SSIS) for automation of data conversion for data warehousing & data reporting.
Systems Administrator Ts/Sci Joint Base San Antonio, TX
Manages the functionality and efficiency of a group of computers running on one or more operating systems
Tasks in direct support of the government include, but are not limited providing or ensuring the team provides the following services:
Help Desk – Provide customer interface by supporting requirements, such as, network accounts, web browsing (i.e. Internet Explorer), e-mail (i.e.
Outlook), word processing (i.e. Word), spreadsheets (i.e. Excel), databases (i.e.
Access), presentation (i.e. PowerPoint), photo editor, desktop publishing, scanning, writing to appropriate media, telephone voice mail and services, equipment issues, etc. Provide multi-media coordination and assistance supporting the setup of conferences, meetings, and Video Teleconference (VTC) operations.
Problem Resolution – Provide IT support to resolve and document problems, using appropriate ticketing systems. Escalate problems to the appropriate organization or process, when required. Utilize the current customer provided priority matrix as an order to responding to service requests (e.g. trouble tickets).
Core HW and SW – Support for common, standard user workstations, and associated software (standard/common configuration/build) deployed throughout the organization. Review, maintain, and correct any configurations that do not comply with Air
Force and organizational policies. Serve as a single source for Standard Desktop Configuration (SDC) images. Control usage and install SDC on all appropriate workstations.
Build equipment in accordance with latest SDC images and provide equipment install at user desktop.
Ensure Equipment Custodian Officer (ECO) or Unit Software License Manager (USLM) approves all hardware and software prior to use.
Handheld Wireless Devices – Support wireless devices (e.g. smart phones, cellular air cards, etc.) users. To include service setup, maintenance, and end user support.
Specialized Network Support – Support special network user devices and other mission systems and applications deployed within an unclassified/classified environment or network.
Remote Desktop Management – Support capabilities allowing assumption of control of an end user device for problem analysis and resolution.
Moves, Add's and Changes (MAC) requests – Provide specialized support for increasing, decreasing, deleting, and adding, location adjustment of services for devices and applications, and port security requirements.
Email and Chat Services – Design, install, operate, maintain, and support messaging and, collaboration, including Government Personal Electronic Devices/Tablets/Mobile Devices/etc., voice and data plans, supporting servers, end-user mobile, anti-spam, and pop-up solutions.
Help Desk Intranet site – Maintain SharePoint helpdesk intranet site, which contains information on standards, security policies, technology ordering and technical tips and hints.
Help Desk Performance – Measure and provide weekly help desk performance reports to Task Lead, Service Desk Lead, Server Support Lead, or COR. Provide recommendations to make the Service Desk more efficient.
Network Health – Provide troubleshooting and resolution expertise to determine network component and configuration issues/failures.
Technical Assistance – Provide technical assistance to support organizational program initiatives. Coordinate solutions with team leads, supervisors, appropriate managers, specialists and/or Contractor technicians.
Customer Training – Provide formal, informal, and On-the-Job Training, related to help desk applications, to customers and Military/Government internal staff, as required.
Compliance – Ensure all systems comply with IAVA, IAVB, and TCNO direction. This includes, but is not limited to, reviewing, applying, testing, implementing patches, changes in settings, and updating reporting databases.
Utilize existing problem prevention and workload reduction techniques. Recommend enhancements to existing techniques and new techniques to Government staff.
Attend weekly meetings to update Government leadership on status, issues, and resolutions as required.
STIG Compliance- Maintain software and hardware in accordance with applicable Security Technical Implementation Guide (STIG) guidance.
Systems Administration – Team is responsible for Operating System (OS) maintenance of approximately 15 Mission Servers (Unclassified through Top Secret). Most are within a VMWare Platform. The administrators shall install, support, and maintain all computer systems and servers, plan and respond to service outages, and diagnose software and hardware failures to resolution.
Provide system design and analysis. Implement and ensure security preventive measures are fully functioning. Maintain server efficiency by monitoring, enhancing system performance, and maximizing disk space. Maintain current patching requirements by performing Automated Service Interruptions (ASI's) on program/mission specific servers.
System Test and Maintenance – Maintain robust network environment by ensuring system testing and maintenance is complete.
Backups: Install, test, maintain, upgrade and develop production and development servers and application software.
Perform daily, weekly, and monthly scheduled backups on production and development systems to include, validation of backups, backup plan, disaster recovery plan and backup of data prior to ASI. Review audit logs and recover data on operational systems as required. Backup library duties include storage and management of tapes, disks and other magnetic media at customer's location and off-site storage facilities. Run security checklist processes on servers and inform customer of all system downtime planned for maintenance, system patches, upgrades or new releases.
Maintain in accordance with DoD Security Policy: Enforce DoD system and security policies, establish and monitor user accounts, install system upgrades, manage system resources, optimize system efficiencies and ensure only authorized personnel access data
Bachelors Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
2-5 years of directly related experience in systems administration and analysis.
All personnel shall have at a minimum DoDD 8570.01-M and 8140 approved and registered IAT Level II baseline certification, with preferred Security + CE to be considered for this task order.
For more than 50 years, General Dynamics Information Technology has served as a trusted provider of information technology, systems engineering, training and professional services to customers across federal, state, and local governments, and in the commercial sector. Over 40,000 GDIT professionals deliver enterprise solutions, manage mission-critical IT programs and provide mission support services worldwide.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
Data Base Analyst II
Description of Work
This is a repost. Previous applicants are still being considered and do not need to reapply.
The primary purpose of this position is to serve as Senior Database Administrators responsible for various activities related to the design, implementation and maintenance of the more complex database(s) (such as DB2, Oracle, MS SQL) including support in the development, testing, production, and maintenance of databases. Other job responsibilities include the following:
Ensuring sound database definitions, structures and documentations
Maintaining and monitoring the database environment(s)
Designing and analyzing policies, procedures, and standards relating to database management
Providing ORACLE/DB2/MS SQL consultation and technical support to the Application Developers on new development and maintenance projects, tuning test and production databases, establishing backup and recovery jobs for database files, performing required utilities, proactively seeking out issues before problems arise, providing analysis of trends to prevent future problems
Advising all levels of management on technical direction for projects plus repairs, translating technical issues for non-technical people
Serving as key technical expert for complex problems, coaching team members while providing technical assistance
Creating database standards for the department, using their advanced technical expertise
Providing consultation regarding best solutions for maintenance, repairs, and projects
Leading projects using project management methodologies
Salary Grade IT09; Recruiting Range $82,485 - $111,501
About The Office of NC FAST:
North Carolina Families Accessing Services through Technology (NC FAST) is a program designed to improve the way the DHHS and the 100 county departments of social services conduct business. NC FAST introduces new technological tools and business processes that will enable staff to spend less time performing administrative tasks and more time assisting families. Knowledge, Skills and Abilities / Competencies
To receive credit for all of your work history and credentials, you must list the information on the application form. Any information listed under the text resume section or on an attachment will not be considered for qualifying credit. Qualified applicants must document on the application that they possess all of the following:
Experience in information systems activities
Experience providing technical support for projects on mainframe and distributed environments
Experience in systems database development tools
Proven ability to effectively communicate in written and oral form with end-user, management and establish effective working relationships.
Experience with ORACLE environments and software
- Advanced knowledge of distributed operating systems
- 3+ years managerial experience
Minimum Education and Experience Requirements
Bachelor's degree in Computer Science, Computer Information Systems, Computer Engineering, Math, or Engineering, or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated data base system;
Associate degree in Information Systems, Computer Programming, Database Management, Computer Engineering, Math, or Engineering from an appropriately accredited institution and five years of progressive experience in programming and applications analysis including the design and maintenance of an integrated data base system;
An equivalent combination of education and experience.
Supplemental and Contact Information
The North Carolina Department of Health and Human Services is an Equal Opportunity Employer
Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account. You will either receive a call to schedule an interview or an email notifying when the job has been filled.
For technical issues with your applications, please call the NEOGOV Help Line at 855-524-5627. Applicants will be communicated with, via email only, for updates on the status of their application. If there are any questions about this posting other than your application status, please contact HR at 919-855-3480.
Data Base Systems-Ce/Voc: Adjunct / Substitute Instructor Pool (Non-Credit)
Posting Details (Default Section)
Closing Date: Open Until Filled No Classification Title DATA BASE SYSTEMS-CE/VOC: Adjunct / Substitute Instructor POOL (non-credit) Working Title Adjunct Faculty Recruitment Limits Location District Wide Pay Information
At the time that an offer of assignment is made, proper salary placement is contingent upon receipt of OFFICIAL (sealed) transcripts and Verifications of Previous Work Experience (if applicable). Instructors with advanced coursework and/ or experience shall be placed on the appropriate class and step on the Adjunct College Salary Schedules, effective the first month following receipt (in Human Resources) of the official transcripts and Verifications of Previous Work Experience (if applicable). Initial salary placement will be at the first class/step until all required documentation has been submitted.
Click here for the current salary schedule or you may view the current salary schedule by using the "Salary Schedules" link to the left.
If you would like to open the link in a different tab or window, right click and select the option.
FLSA Status Exempt (does not accrue overtime) Position Type Adjunct Bargaining Unit: AFT/Continuing Education Faculty Range (na) Department District Wide The Position
NOTE: The San Diego Community College District accepts applications for adjunct (part-time/substitute) positions for our three college campuses (City, Mesa, Miramar) and various continuing education centers on a continuous basis. However, it does not necessarily imply there are immediate openings. If you meet the required minimum qualifications, your application will be included in the adjunct pool for possible assignments in the fall, spring, and/or summer semesters of the academic year. Hiring departments utilize the adjunct pool when there is a need and will contact you directly should you possess the qualifications they are seeking. Applications are purged approximately one year from submittal, at which time you will receive an automated e-mail notice to re-apply if you wish to remain in the pool.
Part-time/temporary faculty positions offer flexible hours and the opportunity to assist a diverse group of adult students in achieving their educational goals. As one of the largest community college districts in southern California, we offer a wide range of opportunities in transfer, general education, vocational and occupational programs. These part-time positions are as-needed and applicants should live within commuting distance to San Diego.
Assignments may include a combination of day, evening, weekend, and/or off-campus classes.
Primary duties of adjunct faculty members are related to curriculum and teaching; the assignment is divided between lecture and lab classes as determined by the department. Adjunct instructional faculty are required to be available to students outside of class.
Provide instruction in accordance with established curriculum and course outlines.
Maintain appropriate standards of professional conduct and ethics.
Maintain current knowledge in the subject matter areas.
Fulfill professional responsibilities of a part-time/temporary faculty member.
Teach all scheduled classes.
Maintain accurate records.
Provide quality instruction, create and maintain an environment which emphasizes teaching and learning and encourages free discussion of ideas, interests and issues.
Degrees must be from regionally accredited institutions.
1.A Bachelor's degree AND two (2) years of occupational experience related to the subject of the course taught; OR,
2.An Associate degree AND six (6) years of occupational experience related to the subject of the course taught; OR,
3.Possession of a full-time, clear California Designated Subjects Adult Education Teaching Credential authorizing instruction in the subject matter; OR,
Desired Qualifications Equivalency
If you do not possess the exact degrees listed above or if you anticipate receiving the required degree prior to the start of teaching classes, please complete a "Request for Equivalency Form" (link to the left) and attach it during the application process.
Applicants with foreign degrees from colleges or universities outside of the United States must have their coursework evaluated by a professional association that is a member of the National Association of Credential Evaluation Services (NACES). A copy of the evaluation must be submitted with your on-line application.
[If possess] Full-time, clear California Designated Subjects Adult Education Teaching Credential authorizing instruction in the subject matter
Commitment to Diversity:
All applicants must have demonstrated cultural competency and sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students, faculty and classified professionals.
Special Instructions to Applicants: Working Conditions
Variable, depending on assignment.
Conditions of Employment: Additional Information:
Newly hired faculty members are required to submit official transcripts and pay a fingerprint processing fee.
All new SDCCD employees must provide a Certificate of Tuberculosis Exam for initial appointment, and must renew the certificate every 4 years as a condition of continuing employment.
Please note that an employee may be transferred to any site at the option of the Chancellor.
Posting Number AJ00277
Web Developer And Data Base Lead Technology Consultant
Where good people build rewarding careers.
Think that working in the insurance field can't be exciting, rewarding and challenging? Think again. You'll help us reinvent protection and retirement to improve customers' lives. We'll help you make an impact with our training and mentoring offerings. Here, you'll have the opportunity to expand and apply your skills in ways you never thought possible. And you'll have fun doing it. Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life.
The IDE Lead Technology Consultant supports the National Catastrophe Team and regular business claims. They will need to be able to travel to catastrophe field offices on average about one week every two months. They are personally support field operations with the creation and support of custom software applications tailored to the demanding and time sensitive needs of catastrophe operations and strategically important claims projects. Many times, the developer will spearhead projects from concept to implementation, acting in various roles from Business Analyst, Project Manager, Solution Designer, and Application Developer to deliver projects with extreme efficiency.
You will works closely with business partners to identify needs and design technology solutions to overcome process bottlenecks, reduce use of contingent claim resources, reduce compliance risks, or generally increase operational efficiency. They are often required to deliver tactical solutions that can be implemented within a few days. They are responsible for all phases of the application development cycle: beginning with requirements gathering, through release, and ultimately ongoing user support. The IDE Lead Consultant is responsible for building complex or highly integrated applications or modules in existing applications. They work independently, managing their own responsibilities and workload.
Job Description (Cont'd)
- Manages customer communications and resolves escalated concerns, conflicts or issues
Gather, review, critique and evaluate detailed business, functional, and high-level technical requirements including technical recovery, security and audit
Evaluates detailed technical design components and acts as a referral expert in appropriate languages, data, structures, vended packages, techniques and design methods
Maintains component design standards
Design solutions for high-complexity projects
Ensure that design reviews are scheduled and executed; Provide feedback and recommends solutions
Provide/confirm detailed estimates for assigned work units and provide communications for deviations from estimates; Proactively works with project managers to ensure appropriate time is allocated to assigned tasks
Contribute to determining programming approach, tools, and techniques that best meet the business requirements; Promote and define development standards
Perform coding of complex modules, as needed
Job Description (Cont'd)
Ensure project change management approach is followed and that enhancements are appropriately prioritized and developed, and all documentation is completed appropriately
Ensure code review is conducted and certify that code meets quality standards; Reviews and critiques code presented by team members
Lead and organize testing reviews; Track and resolve complex defects and assists in planning efforts of complex functional tests
Define and manage process by which support and technical assistance is performed
Performs root cause analysis to prevent recurrence of problem and manages the resolution of complex problems
Ensure delivery of change management activities supporting production deployments to Developers, Quality Control Analysts, and Environment Management personnel
Design detailed technical components with high-level architecture
Complete component design documents on assigned projects
Develop or confirm detailed project or system change estimates or project plans; Calibrates estimating factors for continuous process improvement
Create enhanced technical documentation and implement changes
Conduct timely structured code reviews to ensure standards and systems interoperability
Ensure that design standards and documentation are followed
Review and critique team members' code
Completes and delivers migration or change management form to above parties
Create scope documents and project log entries for prioritization
Provides ongoing technical support for Catastrophe Applications
Has high degree of familiarity with Catastrophe Applications
Acts as Project Manager, delegating development tasks to junior developers as training and to build familiarity with Catastrophe Applications
Manage vendor relationships
Gain familiarity with IDE Applications
General understanding of computer hardware, software applications and tools
Education: Associates or Bachelor Degree in Computer Science, MIS or equivalent work experience
Plus 5+ years of application development experience
Claims experience or specific industry designation preferred
Depending on assignments, several of these skills may be necessary: Visual Basic, ASP, ASP.NET, C#, CSS, HTML, MS Access, MS Excel, MS SQL, Oracle PL/SQL, SSIS, and Python.
The primary function of the position is:
Designing, coding, testing, deploying custom applications for Claims Operations. Using tools such as Visual Studio, MS SQL Server to develop web applications and automations.
- This is a home based position, which will require 10-15% travel*
The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen.
Good Work. Good Life. Good Hands®.
As a Fortune 100 company and industry leader, we provide a competitive salary – but that's just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, you'll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy.
Learn more about life at Allstate. Connect with us on Twitter, Facebook, Instagram and LinkedIn or watch a video.
Allstate generally does not sponsor individuals for employment-based visas for this position.
Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.
For jobs in San Francisco, please click "here" for information regarding the San Francisco Fair Chance Ordinance.
For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.
It is the policy of Allstate to employ the best qualified individuals available for all jobs without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity/gender expression, disability, and citizenship status as a veteran with a disability or veteran of the Vietnam Era.
Application Data Base Administrator
The Application DBA will be an integral member of the Enterprise Business Intelligence team. Responsibilities include database design, development, and procedural programming as well as ETL design and development. Creating and maintaining diagrams and other documentation will be critical for both support and new development. The DBA will work with technical and non-technical users so communication is key and being able to speak at a functional level or a technical level is a necessary skill for success in the role.
Maintains the organization's databases across multiple platforms and computing environments.
Analyzes and resolves issues related to information flow and content.
Maintains database support tools, database objects, backup and recovery processes & procedures.
Advise Data Architects and Developers on best practices in relation to data models, DDL/DML, and suggest areas of improvement for performance and efficiencies.
Monitors database resource utilization and performance.
Contributes to the library of documentation for database standards, maintenance and support.
Ability to manage projects centered on databases supporting specialized applications.
Keeping abreast of emerging technologies.
Other duties as assigned.
- 10+ yrs experience with SQL DDL/DML/DSL, preferably Microsoft SQL Server
- 10+ yrs experience database development of functions, triggers, and stored procedures, preferably T-SQL
- 10+ yrs ETL experience moving data into, out of, or between databases as well as developing transformation logic.
- 10+ yrs experience with Relational Database Management Systems including backups, memory, logs, jobs, notifications, tuning and security, preferably with Microsoft SQL Server
- 3 yrs experience with databases running on MS Windows Servers and familiarity with the OS and AD security
- 5 yrs experience creating, publishing, and supporting reports in 1 or more reporting tools or generating custom report extracts
- 5 yrs experience designing, creating, populating, and supporting Operational Data stores, Data Marts, and Data Warehouses
- 5 yrs demonstrated ability to review data to understand it for validation, type characteristics, transformation needs, modeling, etc.
- 3 yrs understanding of, and experience with, multiple data load paradigms
- 5 yrs experience working with Application Development teams on their database needs including build/review of the database tables, procedures, objects, security, etc.
- 3 yrs experience in the Financial or Banking industry
Benefits Data Systems Administrator
Our Benefits Data Systems Administrator supports the delivery of accurate and timely benefits administration services including Health & Welfare and Retirement Plan administration in partnership with IT and Finance business partners.
- Bachelor's degree in related field or equivalent experience.
3-5 years of experience in a corporate business function such as Human Resources, Finance, IT, etc.
Advanced PC application experience such as Excel, Access, etc.
Ability to develop and analyze financial reports
Experience with HRIS applications
- None required.
Administer ongoing and annual enrollment daily benefit system activities
Receive and import data files containing new hires, changes and terminations
Generate payroll/vendor feeds, as well as ad-hoc management reports
Process system data updates such as indicative data, election data, dependent and beneficiary data
Gain an understanding of the system interfaces with HRIS, payroll, and insurance carriers
Help develop and maintain system processing documentation
Process and fulfill enrollment worksheets. confirmation statements and other benefit related materials
Assist with system testing; Web, interfaces and system generated reports for new and ongoing systems
Gain an understanding of the plan design, including coverage levels and options eligibility enrollment/change and termination procedures
Assist project team to deliver timely, within budget, and high-quality work
Must be able to apply principles of critical thinking to a variety of practical and emergent situations and accurately follow standardized procedures that may call for deviations. Must be able to apply sound judgment beyond a specific set of instructions and apply knowledge to different factual situations. Must be alert at all times; pay close attention to details. Must be able to work under stress on a regular or continuous basis. Perform other duties as assigned.
CCS is an EOE/Minorities/Females/Vet/Disability Employer
Data Management Administrator
Job ID#: 23191BR
Company: General Atomics Aeronautical Systems
Job Title: Data Management Administrator
Job Category: Program/Project Management
City: San Diego
Full-Time/Part-Time: Full-Time Salary
General Atomics Aeronautical Systems, Inc. (GA-ASI), an affiliate of General Atomics, is a world leader in proven, reliable remotely piloted aircraft and tactical reconnaissance radars, as well as advanced high-resolution surveillance systems.
With general supervision, this position is responsible for the administration of operational aspects of ongoing projects, specifically as it relates to the review, scheduling, tracking, and management of contract deliverables. (Add more detail here if needed)
Duties and Responsibilities
Administers daily operational aspects of one or more ongoing projects; participates in project plan development.
Analyzes project plans to ensure milestones and delivery requirements are met; ensures that all the key parties are advised.
Participates in problem solving with project managers, line managers, and clients.
Develops appropriate electronic and hard copy reports and records.
May represent the organization with outside organizations.
Maintains the strict confidentiality of sensitive information.
Performs other duties as assigned.
Responsible for observing all laws, regulations and other applicable obligations wherever and whenever business is conducted on behalf of the Company. Expected to work in a safe manner in accordance with established operating procedures and practices
Interacts with all levels of project team and management
Reviews contract documents to identify data delivery concerns, data marking and deliverable requirements, and due date criteria
We recognize and appreciate the value and contributions of individuals with diverse backgrounds and experiences and welcome all qualified individuals to apply.
Typically requires a bachelor's degree in business administration or a related discipline. Equivalent professional experience may be substituted in lieu of education.
Must demonstrate a basic understanding of project administration principles, theories, concepts and techniques.
Must have experience organizing, planning, scheduling, conducting, and coordinating work assignments to meet project milestones or established completion dates.
Must possess the ability to understand new concepts quickly and apply them in an evolving environment while contributing to the development of new processes.
US Citizenship Required.
Must be customer focused and possess:
Ability to identify issues, analyze data and develop solutions to a variety of non-routine problems.
Good analytical, verbal and written communication skills to accurately document, report, and present findings.
Good interpersonal skills enabling an effective interface with other professionals.
Good computer skills.
Ability to work independently or in a team environment is essential as is the ability to work extended hours as required.
Travel Percentage Required : 0% - 25%
Clearance Required? No
Making better hires starts with building better job descriptions
- Browse 100s of templates across 40+ industries
- Customize your template with your company info & job requirements
- Post it to 20+ job boards in seconds – for FREE!