We provide IT Staff Augmentation Services!

Active Directory Administrator Resume

Montgomery, AL

SUMMARY

  • Sr. Database Administrator (DBA),15+ years: 6+ years IDMS, DB2 - z/OS, 1 year - DB2- UDB UNIX/AIX, 8+ years MS SQL Server 2016/2014/2012/2008 R2, 6+ years - MS Access.
  • Experience in Active Directory Federated Services (ADFS), Active Directory (AD) Windows System Administrator is responsible for overseeing server and network infrastructure and managing the day to day operations of AD.
  • Proficient in PowerShell scripting and support
  • Experience in Windows Servers 2016 to host the AD/ADFS/WAP servers in the cloud
  • Knowledge of BI tool/ETL tool on Visual Studio 2015/2010/2008 : MS SQL Server integration services (SSIS), reporting services (SSRS).
  • Capable: Transact-SQL and Stored Procedures and Data Warehouses.
  • Experience data security guidelines and guidance
  • Knowledge of networking, computer hardware, server hardware and software troubleshooting
  • Expert Security Administrator with: SharePoint and Active Directory, Active Directory Federated Services,
  • Strong knowledge of Microsoft Identity technologies including Active Directory Federated Services, Active Directory, Windows File Services, and Group Policies and in administering Active Directory and GPOs
  • Good understanding of access management of SQL Security and also Active Directory security and how that impacts data security guidelines on SQL server.
  • Very capable with in-house/custom Functional Metadata Repository, used for maintaining version control of databases, acceptance testing, debugging programs according to business requirements and develop flow diagrams.
  • Proficient with metadata repositories and automated Configuration Management Tools: Serena Dimensions CM agent versioning management, quality assurance, and deployment.
  • Versed in supply chain management warehouse processing environment.
  • Supported the Enterprise Continuity Planning in large enterprise environment.
  • Strong analytical skills and a logical thinker; Able to multi-task and still provide thorough and accurate results.
  • Great interpersonal skills; able to efficiently work in groups or alone, without supervision.
  • Detail oriented workmanship with high self-accountability; fast learner and adaptable to changing environments and willingness to learn new technologies and to teach others.
  • Established methodical procedures to solve highly complex problems with perseverance.
  • Very proficient in fast-paced production and stressful environments.
  • Conducted technical training/presentations for end-users at all organizational levels. Developed training materials and documentation.
  • Excellent analytical, technical, communication, critical thinking and organizational skills.
  • Strong people skills that are reflected in the following: Customer Service Oriented, Team Player, and able to work with a diverse group that could include multiple departments within the company.
  • Knowledge of IT ticketing system Remedy, Jenkins (software development tool)
  • Strong knowledge of MS Office Suite 2010: Advanced Access & Excel skills, PowerPoint, Visio, Project
  • Self-directed; High Ethics, Values / Integrity / Trust
  • Secret DoD/ T1 Security Investigations CAC Level Security Clearance (inactive)
  • Secret DoD/SF85 Level Security Clearance (inactive)

TECHNICAL SKILLS

Databases: IMS, IDMS, DB2 - z/OS, DB2 UDB, MSSQL 2016/2014/2012/2008 R2, Microsoft Access

ETL: SQL Server Integration Services (SSIS), excellent debugging and problem-solving skills

Programming Languages: PowerShell scripting, T-SQL, SQL script, IBM/QMF, SQR and PeopleCode, Java, COBOL

Web Services: Web Services (AWS)

Web Programming: JavaScript Amazon

Operating systems: Windows 10,8, 7, XP, Vista, Windows Server, NT, 20xx, IBM AIX/UNIX

Microsoft: MS Office 2010 (Excel, Word, PowerPoint, SharePoint), MS Project, Access, FTP file Client WinSCP, Windows PowerShell

Software: Jenkins, COBOL/DB2, BMC REORG PLUS, Outlook, Excel, Word, PowerPoint, Publisher, SQL Server Management Studio, Visual Studio 2012 & 2008, 2017 Business Intelligence Development Studio, DB Visualizer, SharePoint, QuickBase, Visio, Team Foundation Server, Top Desk, Tableau, MicroStrategy, WinSCP, Adobe Acrobat, WebSphere, Crystal Reports, Business Objects Enterprise, Eclipse, Adobe, Erwin, ClearCase, ClearQuest, Ticket Management System (PkMS), Warehouse Management Open System (WMoS), IBM BI Cognos tool

ERP: BMC Administrative Tools & Performance Products, BMC Utilities and BMC Monitoring Tools, PeopleSoft HRMS/Payroll/Ben Admin/Financials, PeopleTools 8.22, PeopleCode

Vendor tools: IMB DB2 Utilities, Active Directory, Active Directory Federated Services (ADFS), SharePoint, MS SQL Server Reporting Service (SSRS), MS SQL Server Integration Services (SSIS), TSM (Tivoli)

PROFESSIONAL EXPERIENCE

Active Directory Administrator

Confidential, Montgomery, AL

Responsibilities:

  • Supported the Field Assistance Service (FAS) Web Services (AWS) migration FAS Web Services to AWS GovCloud (an Air Force Cloud Enclave) resolving how to export existing Field Assistance Service (FAS) User Data, transfered, and loaded that data into Active Directory Windows with a PowerShell script
  • Assisted in the refactoring code for the System authenticate application users against the ADFS servers
  • Assisted in defining the processes and procedures for moving user data from SQL Server to Active Directory.
  • Was responsible for managing the day to day operations of Active Directory.
  • Streamlined data security guidelines by designing a security model based on Active Directory security group
  • Optimizied data security guidelines changes and audit security
  • Maintained database AD security/account/role/privilege management and schema management and database monitoring

SQL Server Database Administrator

Confidential, Memphis, TN

Responsibilities:

  • Responsible for leading, migrating, upgrading and managing seven end-of-life servers on multiple Microsoft SQL 2008 database environments, and MS Access Databases and related business applications for Confidential ; SSIS package development/publishing, while ensuring data integrity
  • Assist the Fraud and Security Controls (FSC) team in controlling customer identification processes for security and revenue operations around transportation security, fraudulent shipping and revenue acidities, and bad debt in order to minimize the Enterprises' financial exposure and protect the brand.
  • Implement and validate database upgrades and recommended improvements and best practices
  • Administer multiple Microsoft SQL Server database servers
  • Utilize SQL Management Studio to maintain the health of various SQL databases
  • Maintain SQL SSIS projects, and support integration of information between databases
  • Maintain database security/account/role/privilege management and schema management and database monitoring
  • Resolve mitigation and integration issues related to the implementation of new systems within the infrastructure
  • Evaluate the effectiveness of installed software and programs and resolve all issues
  • Work with Visual Studio 2016, Windows 7/2015/2012/2008/2003

SQL Administrator

Confidential, Montgomery, AL

Responsibilities:

  • Was responsible for supporting The State of Alabama’s Department of Senior Services MSSQL databases running Microsoft SQL Server 2012
  • Monitored the databases for long running processes and sped up those processes.
  • Maintained and monitored SSIS/DTSX packages to transform imported and exported data to and from the databases.
  • Monitored and tuned the overall database performance.
  • Created and modified triggers and indexes to improve the speed of data retrieval and modified constraints on tables.
  • Monitored daily jobs involved in importing and exporting data to 3rd party vendors and partners.
  • Maintained Databases by monitoring databases to proactively correct problems.

Active Directory Administrator

Confidential, Memphis, TN

Responsibilities:

  • Assist in supporting 5+ large servers running Windows 2008 server that acts as both SQL 2008 and file servers
  • Investigate data related issues through use of prior knowledge and ad hoc analysis to determine root causes
  • Debug and troubleshoot SSIS packages and SQL jobs as required to maintain system health
  • Streamline data security guidelines by designing a security model based on Active Directory security group
  • Write queries to perform ad hoc analysis and/or to resolve issues with existing processes
  • Facilitate ongoing server maintenance to insure the scheduling has minimal impact on daily operations
  • Involved in weekend processing support, monthly rotation
  • Manage security access requests to SQL server, file shares and team SharePoint sites
  • Provide email support to peers within workgroup concerning topics including but not limited to data availability, best practices, definitions or explanations of datasets, access to servers or file shares and manipulate data in response to customer requirements
  • Provide email and verbal customer support and assistance solving technical issues
  • Create and maintain jobs and address failures and long running packages
  • Monitor server activity and action blocking and dead locking
  • Watch storage space and perform corrective actions to maintain server up times
  • Document business and technical processes through Excel, Word and SharePoint wiki pages
  • Perform both server and system level administration
  • Monitor jobs and address failures
  • Log problems in our internal ticketing system to track time utilizing TOPdesk, QuickBase and ServiceNow
  • Optimize data security guidelines changes and audit security
  • Answer support questions (both business and technical)
  • Communicate with both business and technical users

Application Data Analyst

Confidential, Memphis, TN

Responsibilities:

  • Assisted client with backlog of report requests using Crystal
  • Worked with end-users to create report speci cations for clinical departments
  • Modi ed existing Crystal reports manipulating the SQL queries
  • Analyzed data and generated useful Crystal reports
  • Worked with departmental managers to outline the specific data needs for each business method analysis project
  • Implemented and tested database upgrades and recommended improvements and best practices to increase efficiency
  • Administered Microsoft SQL Server database servers
  • Utilized SQL Management Studio to maintain the health of various SQL databases
  • Created Linked Servers to obtain data from multiple SQL databases
  • Participated in project plan/timeline and provided input into project management
  • Communicated project status to management and consulted on best practice configuration of systems
  • Performed complex testing and debugging programs according to business requirements activities by constructing SQL scripts
  • Worked with Visual Studio 2010, Windows 7 and Microsoft SQL 2016 databases environment and related Business Intelligence applications utilizing SSIS ETL processes tool, while ensuring data integrity

SQL Server Database Administrator and Business Data Analyst

Confidential, Memphis, TN

Responsibilities:

  • Responsible for leading, migrating, upgrading and managing three end-of-life servers on multiple Microsoft SQL 2008/2005 database environments, and MS Access Databases and related business applications for Confidential ; SSIS package development/publishing and BI Cognos tool, while ensuring data integrity and meeting set timelines
  • Implemented and tested database upgrades and recommended improvements and best practices
  • Administered multiple Microsoft SQL Server database servers
  • Utilized SQL Management Studio to maintain the health of various SQL databases
  • Performed complex acceptance testing activities on the Cognos reporting solutions to validate changes prior to the promotion into production by utilizing the BI Cognos tool
  • Utilized SQL Server Integration Services to import and export data from numerous SQL databases
  • Maintained SQL SSIS projects, and supported integration of information between databases
  • Participated in project plan/timeline and provided input into project management, communicated project status to management and consulted on best practice configuration of systems
  • Performed complex acceptance testing and debugging programs according to business requirements and activities by constructing SQL scripts including the expected results and the validation of test results
  • Initiated troubleshooting database problems and re-starting of broken database jobs and end-user connectivity issues with database applications and software
  • Maintained database security/account/role/privilege management and schema management and database monitoring
  • Resolved mitigation and integration issues related to the implementation of new systems within the infrastructure
  • Produced database design schema for integrating source data into the warehouse management systems
  • Evaluated the effectiveness of installed software and programs and resolving all issues
  • Worked with Visual Studio 2010, Windows 7/2015/2012/2008/2003

SQL Server Database Administrator

Confidential, Memphis, TN

Responsibilities:

  • Was responsible for supporting and managing multiple Microsoft SQL 2005/2008/2012 databases, database servers and related applications for Confidential
  • Monitored SQL database and server performances by identifying and recommending system performance enhancements to improve productivity and increase efficiency
  • Utilized SQL Management Studio to maintain the health of various SQL databases
  • Managed, developed and maintained solutions utilizing SQL Server Reporting Services
  • Utilized SQL Server Integration Services to import and export data from numerous SQL databases
  • Maintained SQL SSIS projects, maintained SSRS projects, and supported integration of information between databases
  • Troubleshot end-user connectivity issues with database applications, and software
  • Was responsible for the researching, investigation and resolution of all production issues
  • Worked with Visual Studio 2010, Windows 7/2015/2012/2008/2003

Business Data Analyst

Confidential, Millington, TN

Responsibilities:

  • Analyzed and updated the Business Process Re-engineering (BPR) and Functional Requirements Document (FRD) covering the NESC Street-to-Fleet supply chain process
  • I assisted as a liaison between the business and IT department in the formulating and defining of the systems scope and objectives through research fact-finding, combined with an understanding of applicable business systems and industry requirements
  • Developed or modified moderately complex information systems standards
  • Analyzed business and user needs, documented requirements, and revised existing system logic difficulties, as necessary
  • Created Functional Requirements documentation for the Bureau of Naval Personnel
  • Worked in some phases of systems analysis and considered the business implications of the application of technology to the current business environment
  • Initiated, identified, researched, analyzed, defined and documents business requirements to support company objectives
  • Used detailed knowledge of application features and functions to assess scope and impact of business needs
  • Identified, communicated, and coordinated with all affected stakeholders for projects, requirement gathering both internal and external by interviewing users
  • Communicated complex technical requirements to nontechnical personnel
  • Identified and documented cross-functional and/or cross-divisional, functional requirements, workflow, information technology resources and distribution paths, and system specifications
  • Conducted and/or participated in the analysis of business processes and functional requirements and in the preparation of appropriate documentation to communicate and validate the information
  • Prepared and presented briefings to stakeholders on complex issues
  • Developed new policies and made changes to existing policies
  • Designed and wrote specifications for interface and conversion needs for data
  • Evaluated alternative operational efficiencies documented and refined system modifications of data elements

SQL Server Database Administrator

Confidential, Memphis, TN

Responsibilities:

  • Managed the SQL Database Administration, business analytics and reporting
  • Supported the oversight of all individual Microsoft SQL Server instances locally at the corporate office and retail locations to support the Warehouse Management System (WMS) and supply chain processes
  • Coordinated and conducted a database audit identifying, evaluating, and mitigating, all users to minimize system vulnerabilities for potential data security guidelines risks
  • Worked with remote groups such as vendors, other Confidential ’s facilities, and or departments
  • Developed and design of database strategies, system monitoring and improving database performance and capacity issues, and planning for current upgrade requirements to SQL Server
  • Provided Performance Tuning, Query Optimization, and utilizing Performance Monitor, SQL Profiler and other related monitoring and troubleshooting database problems and tools
  • Responsible for the installations, configurations, upgrades, administration, monitoring and maintenance of all databases in the organization
  • Responsible for providing operational and development database services, including tracking and resolving database related incidents and requests, responding to database related alerts and escalations
  • Troubleshot and resolved database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues, etc.
  • Maintained the backups, restores, recovery models, database shrink operations, SQL Development updates and troubleshot SSIS packages, T-SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, and constraints)
  • Experienced with creating in-house adhoc reports per requirement to include the full lifecycle for designing and developing business intelligence reports and maintaining solutions utilizing SQL SSRS and enhancing of new project requests to meet the business needs
  • Responsible for the researching, investigation and resolution of all production issues

Hire Now