|
|
Title: |
SQL Server Database Administrator
|
Location: |
US-Georgia-Atlanta
|
Work History: |
Professional Experience:
July 2006-present
CDC Software
Atlanta, GA
Systems Analyst
Provide application support for ERP and CRM solutions (iRenaissance and Pivotal)
Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL
Provide 24/7 coverage on-site and off-side of SQL 2000 and 2005 databases
Perform security updates for all servers.
Design diagrams for different production databases
Transition company databases from SQL 7.0, 2000 to SQL 2005
Develop plans and manage and execute complex technical efforts
Perform DTS packages
Perform Link Servers
Comfortable developing in T-SQL
Write Stored Procedures
Perform Database storage migration
Understanding of complex logical to physical DB structures
Develop Documentation for all Databases.
Jan. 2003- July 2006
The Ginn Group (contract for CDC)
Atlanta, GA
SQL Database Administrator
• Database migrations to new platforms and/or new software versions and SQL Server related products; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc. Design and implementation of database backups and restores strategies as it relates to SQL Server and it’s related services; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc.
• Responsible for creating system and user stored procedures, triggers and functions using Transact-SQL (T-SQL) for enterprise-level Visual Basic and Web applications.
• Design of database architectures for efficiency
• Data modeling with tools like Rational Rose, ER Win/BP Win
• Database performance and tuning
• Systems monitoring
• Database applications support, i.e., schema changes in production, testing, staging instances, etc…
• Troubleshooting of database software
• Database software upgrades
• Testing and evaluating of patching strategies
• Capacity planning and developing recommendations
• Creating and enforcing standards and policies as it relates to SQL Server and it’s related services; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc.
• Scheduling, automating, executing, and monitoring of job and system performance as it relates to SQL Server and it’s related services; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc.
• Ongoing monitoring of SQL server operations and it’s related services; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc.
• Coordinate with Functional DBA’s on database operations, hardware architecture, security as it relates to SQL Server and it’s related services; Integration Services, Replication Services, Notification Services, Analysis Services, Reporting Services, etc.
• Currently working with SQL Server 2005 ( migrating databases from earlier versions, connectivity to SQL 2000 database and also use the query browser to execute SQL scripts and to create queries.
System Analyst III
Involved with many LAN and domain updates, such as the removal of Novell from ITSO network and deployment of Windows 2000.
Responsible for the installation, configuration and maintenance of all SQL Server 7.0 and 2000 systems in our local division (25 systems).
Responsible for backups, data integrity and scripting on all SQL Servers.
Responsible for the installation, configuration and maintenance of all Rational Software on servers, desktops and laptops.
Mar. 2001-Jan. 2003
Computer and Hi-Tech Management (Contract for CDC)
Atlanta, GA
-Responsible for the installation, configuration and maintenance of all desktops and printers (network and local) on LAN.
-First line of support for IRMO users with any hardware, software or network issues, including password resets and account setups.
-Assisted LAN administrators with server setups and adding them to the domain.
-Administered several SQL 2000 servers; servers were used nationwide by other branches of the Federal Government, including The Department of Defense, the State Department and the Department of Homeland Security. (Installation of SQL 2000 server software, setup of default and named instances, SQL user account creations, password changes, database creations, database backups and restores, writing and submitting T-SQL scripts for developers and testers)
Oct. 1999-Mar. 2001
OneSource, Inc.
Atlanta, GA
(Help desk Support II / Desktop Support / Jr. Network Administrator)
(Junior Network Administrator)
-Connected multiple users on company LAN and WAN.
-Assisted in installations of cabling, hubs, switches, and routers as well as the installation of phone and LAN jacks within the office.
-Aided Network Administrator with the maintenance of the list of static IP’s and maintenance of DHCP servers.
-Assisted Systems and AS400 operations personnel with giving users access to company’s AS400 on an NT network via IBM AS400 Client Access and Hostfront by Farabi.
-Administered Windows 2000 user, email and computer accounts (Exchange 5.5, Active Directory, RAS, and deployment) (Servers were previously Windows NT 4).
-Aided Network Administrator with adds, moves, and deletions of satellite offices to the LAN/ WAN. -Coordinated with satellite office managers and telecommunication vendors to get offices on-board LAN/ WAN.
-Assisted in the deployment of Windows 2000 to a 200-person office.
-Administered dial-in access for users via RAS server.
-Implemented several basic telecommunication tasks, such as assisting with connectivity to telephone PBX and creating analog telephone lines for modems.
-Attached print servers to single domain network environment.
-Aided remote users and satellite offices with connectivity to the home office via dial-up modems, ADSL, ISDN, and 56k frame relay circuits.
(Desktop Support)
-Installed and configured multiple hardware peripherals (such as CD-RW’s, zip drives, scanners, printers, etc).
-Visited internal users with software of hardware issues.
-Installed company copies of standard soft wares (Norton Anti-Virus 2000, Adobe Acrobat Reader 4.05, WinZip 7.0 and Microsoft Office 2000) on all new computers that were then shipped to satellite offices throughout the country.
-Was in charge of Asset Management for all computers and peripherals such as printers, monitors, modems, zip drives, etc.
-Administrated the Break/Fix to all machines internal and external to the home office.
-Was in charge of the maintenance and ordering of ink/toner cartridges for all printers and fax machines. -Manually installed applications and operating systems on a wide variety of computers makes and models, such as HP, IBM, and Compaq.
(Helpdesk Support Level II)
-Provided Level 2 phone support for many Microsoft applications such as MS Office 97, and 2000.
-Provided Level 2 phone support for MS Windows 95, 98, NT 4.0 and 2000 operating systems.
-Used Remedy for trouble ticketing.
-Monitored call volume for number of open and closed calls.
-Assisted Level I agents with more difficult issues and troubleshot them further for call solution.
-Escalated (when necessary) these more difficult issues to the proper personnel or the proper vendors for problem resolution.
Jan. 1999-Oct. 1999
Hewlett-Packard, Inc.(HP)
Kennesaw, GA
-Provided Level 2 application support of Microsoft Office 95, 97, and 2000 via telephone.
-Supported customer requests for HP’s internal voice/data installs by interacting with internal and external vendors, local telecommunication providers, etc.
-Used AGO and TMO Clarify for trouble ticketing.
-Coordinated hardware support and break-fix with HP hardware technical support and hardware pick-ups.
-Provided technical support for internal HP employees in other times zones including Corvallis, OR and London, England.
Mar. 1998-Jan. 1999
International Business Machines, Inc. (IBM)
Kennesaw,GA
-Provided Level 2 application support of Microsoft Office 95 and 97, MS Exchange Server/ NT Client and Server 4.0 Lotus SmartSuite 97, Corel WordPerfect Suite 8, and Novell GroupWise 5.5
-Provided end user /server support for Novell Netware
- Provided minimum functions on AS/400 (Varied printers and re-enabled user accounts)
|
Skills: |
Technical Skills:
-Strong, working knowledge of developing ASP, ASP.NET, and PHP web applications using database technologies like MySQL, SQL 2000, SQL 2005 and MS Access 2000-2003.
-Strong working knowledge of SQL Server 2000/2005 using T-SQL, Stored Procedures, Triggers, ETL, Backup/Restore, Replication, Indexes, Normalization, SQL 2005 Business Intelligence: Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)
- Proficient knowledge of Web Technologies: HTML, CSS, Javascript, AJAX, Linux, Apache, MySQL, PHP (LAMP)
- Former Rational Administrator for Enterprise. Support for the users includes: software installation, user security, project creation and modification, upgrades and maintenance. Working administrative knowledge of Rational Clear Case, Clear Quest, Rose, Test Studio (Robot, Test manager, Team Test, etc), Requisite Pro and Project Console.)
- In depth knowledge of SQL Server 2000 (installation, maintenance, security, database performance tuning, backups and data recovery).
- In depth knowledge of multiple enterprise-level, large scale network operating systems (NOS) including Windows NT 4.0, Windows 2000 and Windows 2003. This includes their installation, configuration and management in a high availability environment.
-In depth knowledge of network configuration and installation including hardware such as cabling (Ethernet 10 and 100BaseT, Coax, Token Ring), hubs, routers, switches, NIC installation and configuration, and protocol setup/configure (TCP/IP) on an enterprise level.
-In depth knowledge of network administration, management, and support.
-In depth knowledge of applications which integrate with enterprise-level email/messaging systems
-In depth knowledge of PC hardware and software installation/configuration and support.
-Proficient knowledge of enterprise-level project planning including technical and non-technical personnel and management relations.
- Functional knowledge of Exchange 5.5 and 2000 email environment including server implementation, daily management/operations and troubleshooting.
-Strong, working knowledge of IIS 5 and IIS 6 using Windows 2000 and Windows 2003. Defining security for IIS and virtual directories.
-Strong knowledge in MS Office 2000, XP and 2003; including Word, Excel, PowerPoint, Outlook, Access, Publisher and Front Page. Strong, working knowledge of Windows 95, 98, NT4, 2000, ME and XP.
- Won 2 Customer Service Awards for Excellent Service (OneSource) and won "Employee of the Month" At IBM (cash award).
-Studying for MCDBA certification.
-Type: 45 wpm
Certifications:
(MCSA) Microsoft Certified Systems Administrator
(MCSE) Microsoft Certified Systems Engineer on Windows 2000
- (Microsoft Transcript is available upon request).
- Have completed Microsoft courses : Course 2733-Updating Your Database Administration Skills to Microsoft SQL Server™ 2005 and Course 2734- Updating Your Database Development Skills to Microsoft SQL Server™ 2005
|
Education: |
Education:
1988-1992 Bainbridge High School Bainbridge, GA
College Prep. Diploma (1992)
1992-1994 Bainbridge College Bainbridge, GA
A.A.-Chemistry (1994)
A.A.-Mathematics (1994)
1996-2000 Kennesaw State University Kennesaw, GA
B.S.-Chemistry (2000)
2006-present Southern Polytechnic State University Marietta, GA
M.S.-Information Technology (2008-projected)
|
Endorsements
|
 |
Albert has received 0 endorsements.
|
Albert has endorsed 0 Members.
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
Public Messages
|
|
| From |
Date |
Message |
GA Department of Human Resources |
05.30.08 |
please contact me regarding SQL Server Developer/DBA
404-657-4844
bveasey@dhr.state.ga.us
Byron Veasey |
GA Department of Human Resources |
05.23.08 |
Albert,
could you be available Wednesday at 10 am for an interview? We are 2 Peachtree St in downtown Atlanta (Marietta & Peachtree), near the Underground. We are on the 4th floor.
My office number is 404-657-4844 |
|
|
